Remove inbuild commas from CSV.

Question

I have csv file , all the values of column is separated by "," .
Some column have embedded comma "," . How can i Remove these embedded commas
These embedded commas creating problems to extract value from csv file.
I am using shell script.

Answer 1

Try something like this -

tmpFile=$input"Temp"
sed 's/\(\"\)\(.*\)\(,\)\(.*\)\(\"\)/\1\2\3\4/'  < $input > $tmpFile
cp $tmpFile $input
rm $tmpFile