Hello,

I have a field within my data set that has variable number lengths and a '#' sign prior to a person's full name. See an example below:

11#Doe,Jane
123#Smith,John
12223#Doe,John

Is there a function that would allow me to only return the string after the '#' sign, even though the characters prior to it have a variable length?

Thank you!

How about GETTOK or TOKEN functions ?

I was able to use the functions below:


DEFINE FILE EXAMPLE
POSITION/I3 = POSITV(NAME,30,'#',30,FOUND);
EMP/A30 = SUBSTV(30,NAME,POSITION+1,30,EMP);
END

Thank you!