Focal Point
[SOLVED] how to split the string

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

June 14, 2018, 07:51 AM
Kalai
[SOLVED] how to split the string
I have string like "zzzxxxxxyyyy / xxx / ghagdahdagh". How to split the string using delimiter "/".

My expected result is: xxx

How to perform this activity in data migrator ?

Kindly help us to resolve this issue.

Thanks
Kalai

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
June 14, 2018, 11:51 AM
FP Mod Chuck
Kalai

Using the synonym editor against the master file where this field is described. Create a DEFINE'd field and use the GETTOK user function with / as the delimeter.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
June 14, 2018, 05:05 PM
Waz
In version 8.1, there is a simplified function called TOKEN

e.g.
MYSTRING/A100 = 'zzzxxxxxyyyy / xxx / ghagdahdagh' ;
XXXSTRING/A10 = TOKEN(MYSTRING,'/',2) ;


Check it out in the documentation.


Waz...

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

June 20, 2018, 06:55 AM
Kalai
Thanks for your informations. It is working fine.


WebFOCUS 8
Windows, All Outputs
June 20, 2018, 05:08 PM
Waz
Kalai,

Please update the title of this thread, and add [SOLVED] or [CLOSED] depending on satisfactory answers.


Waz...

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