.csv file

[jinkys]

I have a .csv file in the following format

123,"abc",456,"def,ghi",789

Anyone know how I can change the delimeters in this from comma to pipe (|)? noting there is a comma within a text field.

 

[PHV]

A starting point:
sed 's/\([0-9"]\),\([0-9"]\)/\1|\2/g' /path/to/input.csv > output

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[tchatzi]

or simply

sed 's/,/|/g' old.csv > new

``The wise man doesn't give the right answers,
he poses the right questions.''
TIMTOWTDI

 

[jinkys]

thanks guys but I've decided to use the quotewords function in perl

 

[PHV]

perluserpengo, have you read the OP ?
noting there is a comma within a text field

 

[tchatzi]

Sorry dude i didn't see that. My appologies


``The wise man doesn't give the right answers,
he poses the right questions.''
TIMTOWTDI