topic sed string replacement in Operating System - HP-UX

sed string replacement

Camel_1 — Wed, 26 Apr 2006 09:46:50 GMT

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

Re: sed string replacement

James R. Ferguson — Wed, 26 Apr 2006 10:03:40 GMT

Hi Simon:

Try:

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

Regards!

...JRF...

Re: sed string replacement

Patrice Le Guyader — Wed, 26 Apr 2006 10:28:55 GMT

Demat Simon,

I assume that your filename is toto :

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

Hope this helps
Kenavo
Pat

Re: sed string replacement

Peter Nikitka — Wed, 26 Apr 2006 10:38:58 GMT

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

Re: sed string replacement

Camel_1 — Wed, 26 Apr 2006 12:30:46 GMT

thanks