Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to remove values before a certain character in a field, see example below:
Current field value
101 - 204
10 - 304
20 - 30
What I want to see is
204
304
30
So in other words I want to remove all values before a hyphen so that the last few values are shown.
Any suggestions?
Thanks,
Ralph
load
field,
subfield(field, '-', 2) as newfield,
....
Trim(Mid(myField, Index(myField,'-')+1))
let me know
Hi,
Try =Right(testfield,Index(testfield,'-')-1)