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.
Splitting single column values(length not fixed)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Yo ho!!!! This works.Resolved
[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.
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.
hcdiss