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
Solved! Go to 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
Did you try creating a field of right([data],3) and a field of trim(replace([data],[currency],""))
cheers,
mark
Thanks guys, I figured out in the meantime...I had my 3 in "3" this form, which I overlooked.
Thanks once again!
MateK