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
