Split column-inconsistent data

[EtamSoko]

hi Everyone,

I got stuck with a seemingly simple solution for one issue of mine. I have a column which could include from 3 to 70 characters but regardless of their numbers, I wanna split by the last 3 character (currency).

I found solution using regex formula but it is rather for consistent data.

I really appreciate your help in advance!

Regards,

MateK

[afv2688 · Accepted solution]

Hello @EtamSoko ,

You can use the function  Right([Field], 3)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[MarqueeCrew · Accepted solution]

Did you try creating a field of right([data],3) and a field of trim(replace([data],[currency],""))

 cheers,

 mark

[EtamSoko]

Thanks guys, I figured out in the meantime...I had my 3 in "3" this form, which I overlooked.

Thanks once again!

MateK