remove unnecessary comma from file

UNIX for Advanced & Expert Users
1

HI all,

I have a file with following data - test1

"ABC,D",1234,"XYZ,QWER",1234
"SZXA",9870,"ASD,QWERT",234
"XZ,SD",9478,"ADCS,AXZ",876
"WESR",8764,"AQZXAS",9888
"WESR",9898,"WESDRTSAW",3323

I need to get rid of unnecessary commas in fields having double quotes.

Ouput -

"ABCD",1234,"XYZQWER",1234
"SZXA",9870,"ASDQWERT",234
"XZSD",9478,"ADCSAXZ",876
"WESR",8764,"AQZXAS",9888
"WESR",9898,"WESDRTSAW",3323

I am trying follwing but of no avail.

sed 's/\,/\"^["]\"' test1
sed: 0602-404 Function s/\,/\"^["]\" cannot be parsed.

I work on AIX.

Any help is appreciated.

Thanks
Sumeet

2

Hi,

try:
command:

sed 's/\("[^"][^,]*\),\([^"]*[^,]"\)/\1\2/g' commafile

input:

"ABC,D",1234,"XYZ,QWER",1234
"SZXA",9870,"ASD,QWERT",234
"XZ,SD",9478,"ADCS,AXZ",876
"WESR",8764,"AQZXAS",9888
"WESR",9898,"WESDRTSAW",3323

output:

"ABCD",1234,"XYZQWER",1234
"SZXA",9870,"ASDQWERT",234
"XZSD",9478,"ADCSAXZ",876
"WESR",8764,"AQZXAS",9888
"WESR",9898,"WESDRTSAW",3323

HTH Chris