Convert an Input file(CSV) to pipe delimited.

I am using Talend and the schema changes for an input file (csv) that I want to convert to pipe delimited. The csv file has double quote (") text qualifier and within the quotes I don't want the comma to be a pipe. A tReplace replaces every comma. Basically I need the following lines
117, 728, Pin- 201012

15, 65, "27 Sector, Noida"

"8,506", 552, "Vasundhra, Ghaziabad"

to be

117|728|Pin-201012

15|65|27 Sector, Noida

8,506|552|Vasundhra, Ghaziabad

Tagged:
Sign In or Register to comment.