Split column-inconsistent data

Question

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 Answer

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 Answer

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

cheers,

mark