Splitting single column values(length not fixed)

[hcdiss]

Problem :

I have a column named : N_NAME_SEEK
Data in this column is as under :

N_NAME_SEEK
joe,robot,mr
jain,juhi,miss
lee,bruce,dr

I want to split this data in 3 respective fields, FIRST NAME,LAST NAME,TITLE

So output i want is :

FIRST NAME LAST NAME TITLE
robot joe mr
juhi jain miss
bruce lee dr

Since N_NAME_SEEK does not contain fixed length data i cannot use substring.Please suggest some solution.

[bkumar103]

Hi
From example it looks like comma seperated?
Is it really comma seperated?
You can use the column export stage to split into multiple columns.

[nani0907]

If you are getting comma in the input data then use field function and output the data.

[chulett]

For example:

Field(Link.N_NAME_SEEK,",",1,1) = First Name
Field(Link.N_NAME_SEEK,",",2,1) = Last Name
Field(Link.N_NAME_SEEK,",",3,1) = Title

[ray.wurlod]

Use a Column Import stage to do the parsing for you. Upstream the "first line is column names" (so ignore the first line) is asserted. Or trap that on the reject link of the Column Import stage.

[hcdiss]

[quote="chulett"]For example:

Field(Link.N_NAME_SEEK,",",1,1) = First Name
Field(Link.N_NAME_SEEK,",",2,1) = Last Name
Field(Link.N_NAME_SEEK,",",3,1) = Title ...[/quote]


I used Stage variable in Transformer stage with this function and this works!!!!!
Thanks a lot
We can mark this as resolved.