How to get a 4th character from the right of a string

[premkav]

Hi

I have a column that contains a alpha numeric values with a "-". The position of this - varies across the values.

All i need is the 4th character from the right of the string. What is the way to get this. In excel I used the left right formula for the same.

Eg - 123abc-001 (In this case i need the -)

        234defgh02 (In this case i need g)

Regards,

Avinash Prem Kumar

[LordNeilLord · Accepted solution]

Hey @premkav 

I would do Substring(ReverseString([Field1]),3,1)

[rkapoor · Accepted solution]

@premkav have a look at the attached workflow.

[grazitti_sapna · Accepted solution]

Hi @premkav , you can try this if it helps.

 I have mentioned 2 different ways to solve this problem.

Thanks.

[premkav]

Thanks. This works ..

[premkav]

Thanks RishiK

[premkav]

Thanks grazitti_sapna

Both the solutions are good.

[grazitti_sapna]

@premkav  thanks.