Shell Programming and Scripting

Hi ,

Im relatively new to unix and have to process a comma serparated flat file . I recieve some of the fields in double quotes and i want to remove it ..

INPUT
====
filed1,field2,field3,"fie,ld4"

OUTPUT
=====
field1,field2,field3,"field4"


can anyone tell me how to achieve this .

What do you want to remove, double quotes ? Your OUTPUT is not really clear on this point.

kindly use the below code:-

Code:

sed 's/\(fie\),\(ld4\)/\1\2/g'

I want to remove the commas that will come within double quotes ...

filed1, field2,field3,"fie,ld4"

i want to remove the comma in "fie,ld4" so that the output is

field1,field2,field3,"field4"


note : field name are just dummy that i am using , data can be anything in strings like

rahul,rohan,ansal,"bankofbaroda,dehi"

iwant to remove the comma in "bankofbaroda,delhi"

Assumes that only one word in the line will have double quotes

Code:

echo '"file,d1",field2,field3,field4' |  sed 's/\(.*\)"\(.*\),\(.*\)"\(.*\)/\1"\2\3"\4/'

output
"filed1",field2,field3,field4

Code:

an easy way is

sed 's/\(.*\),\(.*\)/\1\2/g'

Code:

Code:

an easy way is

sed 's/\(.*\),\(.*\)/\1\2/g'

Reply With Quote

Code:

It will work only in case of the double quoted string at the end