Nov 22, 2014, 7:16 AM
Post #1 of 2
READ CSV and change delimiter
I am new to PERL
I have a CSV file with below
I will like to convert this CSV file to
Need to change the delimiter "," to ";"
If cell is wrapped with " then we want to retain comma
If cell is wrapped with " and has multiple lines, convert to
a single line, and insert ~ as a line indicator
Can you tell me how we can accomplish this in PERL?
(This post was edited by takahirata on Nov 22, 2014, 7:17 AM)