find & replace comma in a .csv file.

Shell Programming and Scripting
1

HI,

Please find the text below. I receive a .csv file on server. I need the comma(,) in the second column to be replaced by a semi-colon( ; ).

How to do it. Please help.

Sample text:

"1","lastname1,firstname1","xxxxxx","19/10/2009","23/10/2009","0","N","Leave"
"2","lastname2,firstname2","xxxxxx","12/10/2009","16/10/2009","0","N","Leave"
"3","lastname3,firstname3","xxxxxx","29/10/2009","30/10/2009","0","N","Leave"

thanks.

2

By sed:

sed 's/\(lastname[0-9]\),/\1;/' urfile
"1","lastname1;firstname1","xxxxxx","19/10/2009","23/10/2009","0","N","Leave"
"2","lastname2;firstname2","xxxxxx","12/10/2009","16/10/2009","0","N","Leave"
"3","lastname3;firstname3","xxxxxx","29/10/2009","30/10/2009","0","N","Leave"

By awk

awk 'BEGIN {FS=OFS=","} {print $1,$2";"$3,$4,$5,$6,$7,$8,$9}' urfile
"1","lastname1;firstname1","xxxxxx","19/10/2009","23/10/2009","0","N","Leave"
"2","lastname2;firstname2","xxxxxx","12/10/2009","16/10/2009","0","N","Leave"
"3","lastname3;firstname3","xxxxxx","29/10/2009","30/10/2009","0","N","Leave"
3

Another way:

awk -F "\"" '{sub(",",";",$4)}1' OFS="\"" file