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,

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.

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.

Thanks for your informations. It is working fine.

Kalai,

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