Removing commas within semicolon in a flat file

r_t_1601 · #1 (**permalink**) 06-16-2009

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 .

isatis31 · #2 (**permalink**) 06-16-2009

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

ahmad.diab · #3 (**permalink**) 06-16-2009

kindly use the below code:-

Code:

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

r_t_1601 · #4 (**permalink**) 06-16-2009

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"

panyam · #5 (**permalink**) 06-16-2009

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

ahmad.diab · #6 (**permalink**) 06-16-2009

Quote:

Originally Posted by r_t_1601

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"

Code:

an easy way is

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

panyam · #7 (**permalink**) 06-16-2009

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Need help in removing commas	ali560045	Shell Programming and Scripting	1	04-21-2009 03:04 AM
removing semicolon using sed in aix--urgent	aixjadoo	UNIX for Dummies Questions & Answers	9	06-16-2008 01:41 PM
Removing trailer from a flat file!!!	kumarsaravana_s	UNIX for Dummies Questions & Answers	12	06-24-2007 03:53 AM
Padding zeros after removing commas in file	pranag21	HP-UX	1	11-09-2005 10:22 PM
removing commas from text file	hcclnoodles	UNIX for Dummies Questions & Answers	6	03-26-2003 04:43 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: