I have a one column which has
id,tax_input,tax_amt,tax_address | id,tax_input,tax_amt,tax_address
I want to split this into records based on delimited '|'
id,tax_input,tax_amt,tax_address
id,tax_input,tax_amt,tax_address
this should happen on dynamically based on '|' as record separator.
Split big column into records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Which version of datastage you are in.?
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
I am assuing you are in 8.5 or above version,you can check below post,I have given solution,you need to apply only one transformer,check only logic for tsfm2
viewtopic.php?t=149150
viewtopic.php?t=149150
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If the source file is a text file, you could use a Filter command such as sed or awk to convert the pipe delimiters into line terminators. (Even though you are on Windows, the MKS Toolkit provides these commands.)
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.