Hi Community,
I have a column in my data set that looks like below and I want to keep only the characters right to the "-". I wanted to use formula tool and the trim function to do this, but I do not have enough experience to apply my logic. Can anyone help? Thanks in advance!
Somekind of ID |
ARC-22 |
BABAHSBB-231 |
CAP-12b |
I would want my end result to look like this:
Somekind of ID |
22 |
231 |
12b |
Solved! Go to Solution.
Find the easy weay
Left([Field], ToNumber(FindString([Field], "-")))
where "-" is the reference from where you want retrieve the values to the left
What is the meaning of +1? I assume to the right of "-".
Thank you