Hi All,
I want to convert the CSV file to Pipe delimited file
Ex:"aaa","bbb",""Wow!!!" this is good","ddd" to
aaa|bbb|"Wow!!!" this is good|ddd
Experts ideas will really help.
Thanks in advance.
Convert CSV to Pipe delimited
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Sequential File stage to read (import) the data using comma as the field delimiter (this is a Format property).
Sequential File stage to write (export) the data using pipe as the field delimiter (again on the Format tab).
Voila!
You have already posted about handling of nested quote characters, so I do not propose to revisit that topic.
Sequential File stage to write (export) the data using pipe as the field delimiter (again on the Format tab).
Voila!
You have already posted about handling of nested quote characters, so I do not propose to revisit that topic.
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.
Re: Convert CSV to Pipe delimited
If you already have a file Created then you hae to recreate thorugh Datastage Job.kogads wrote:Hi All,
I want to convert the CSV file to Pipe delimited file
Ex:"aaa","bbb",""Wow!!!" this is good","ddd" to
aaa|bbb|"Wow!!!" this is good|ddd
Experts ideas will really help.
Thanks in advance.
Seq File Stage ---> Copy ----> Seq File Stage.
In the output go to Format Tab and Choose the Delimiter as Pipe.
If you want quote you can use it or else leave it as is.
If you want to handle Null Handling please Assign Null Value which ever you want.
ou shoul dnot face any issue.