Shell Programming and Scripting

Hi friends...

I have a dat file like below:-

test_file.dat

Code:

abc,ttt,"""123,89.98",yyu,opp
vvv,"23,76.68",w564,"54,98.87",985

i need the remove the comma present inside the double qoute as output:-
out_test_file.dat

Code:

abc,ttt,"""12389.98",yyu,opp
vvv,"2376.68",w564,"5498.87",985

please help me on this

Thanks in advance..

Moderator's Comments:

Use code tags please, see PM.

Try:

Code:

awk -F\" -vOFS="\"" '{for (i=2;i<=NF;i+=2) sub(",","",$i)}1' file

Alternatively:

Code:

awk 'NR%2-1{gsub(/,/,x)}1' RS=\" ORS=\" infile

Now, the above two commands working fine

Thank you ...

Gani85 , nice question

Hi friends...

This comand is working fine, but facing an issue while having the input like below:-

Code:

abc,ttt,"""24,123,89.98",yyu,opp
vvv,"1,423,76.68",w564,"54,98.87",985
abc,ttt,"""67,123,89.98",yyu,opp
vvv,"88,523,76.68",w564,"54,98.87",985

If i am having two or three commas inside the double quote, i am not geting the desired output(the output will be zero commas inside the double quote). This command is removing one comma at a time and i am not sure how many commas will be inside my input file. it may be one,two,three...

Please help me on this.

Thanks in advance..

Moderator's Comments:

Please use code tags!

Hi, did you try my solution? I anticipated multiple commas and therefore I used gsub instead of sub (hence the hightlighting of the letter g)..