Focal Point
Editing Field with Variable Numbers before Text String

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7081057331/m/8067039096

November 20, 2018, 01:45 PM
Laura8219
Editing Field with Variable Numbers before Text String
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!


Webfocus 8.105m, XLSX, EXL2K, HTML, PDF
November 20, 2018, 03:03 PM
Waz
How about GETTOK or TOKEN functions ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

November 28, 2018, 10:45 AM
Laura8219
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!


Webfocus 8.105m, XLSX, EXL2K, HTML, PDF