DSXchange

Hi All,

We have a file with records as below
ABC_123_DATA_RRR_TTT_OOO
ZXC_123_DATA_SSS_PPP_LLL

I want to fetch the all the data after 3rd delimiter
FOR EX: final output should be
RRR_TTT_OOO
SSS_PPP_LLL

Can you please help me on this

Look in appendix B of the parallel job developer's guide for all of the transform functions available. String functions would have options for you: DCount, Index, Field, [].

It would be good to become familiar with what is available.

Mike

Yup! Always best to become conversant with all of the functions at your disposal. Or at least know where to go look for something to do the trick.

For this, Field() would be my first go to function.

Thank you,

it worked with index and field

trim(Columnname[ Index(columnname,'_',3) +1,50])

if the stuff is fixed width you can directly extract what you want more efficiently with right or left type functions.

FYI, the use of Index() is unnecessary as Field() supports not only a start field but optionally how many to return... 1 is the default. Just make sure when you add it that the "how many" value is high enough. I tend to use 99 even if I know there could only be a handful. Makes what is going on more obvious IMHO.

Yeah, the post is resolved, but i usually design my jobs to minimize number of Transformer stages ( a throw back to the past i guess ) - So i would have just read from the sequential file , and used a copy stage to get only the columns after the 3rd position. Or read the whole file as a string and column import after column 3. Or even use a Filter Command like awk to extract anything after the 3rd column and use that filter in the Sequential file stage.