I have an email address and I really only need the part up until the @....so for emails of john.smith@eagles.csc.edu I only want the john.smith........How and where in my report do I put the STRIP command and is this even the right command to use?
MalindaThis message has been edited. Last edited by: Malinda,
WebFOCUS 7.6.11 Windows all output (Excel, HTML, PDF)
July 20, 2010, 11:40 AM
Darin Lee
STRIP would probably not be the best function, as it requires searching for a specific character string, which would vary depending upon the record. I would use the GETTOK function, using the @ as the delimiter.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
July 20, 2010, 11:54 AM
Malinda
So I can just put this GETTOK where in my report code?
WebFOCUS 7.6.11 Windows all output (Excel, HTML, PDF)
July 20, 2010, 01:25 PM
Darin Lee
Define a new field using the GETTOK function as documented in the help file and manuals, and reference the field that contains your email addresses.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
July 20, 2010, 01:56 PM
Malinda
I was actually able to follow the doc and put in right in with my table request..