sed string replacement

[Camel_1]

Hi there,

Suppose a text file contains records such as:
12345,"47,835.33",abc,…

How can I remove the optional double-quote enclosure and thousand separator so as to transform it to:
12345,47835.33,abc,…

Thanks,

Simon

[James R. Ferguson · Accepted solution]

Hi Simon:

Try:

# perl -ple 's/"(\d+),(\d+\.)(\d+)"/\1\2\3/;s/"//g' filename

Regards!

...JRF...

[Patrice Le Guyader]

Demat Simon,

I assume that your filename is toto :

sed -e 's/\"//g' -e 's/\.//g' toto

Hope this helps
Kenavo
Pat

[Peter Nikitka]

Hi,

my solution is in awk:

awk -F, -v quo='"' '/"[0-9,.]*"/ {startq=0;str="";for (i=1;i<=NF;i++) {if($i ~ quo) {startq=!startq;
sub(quo,"",$i)}
str=str""$i;if(!startq && (iprint str;next}
{print}' TEXTFILE

mfG Peter

[Camel_1]

thanks