Comma Delimited file

dbrundrett · #1 (**permalink**) 04-05-2004

I have a comma delimited file that sometimes has addresses details in. The problem is that the address detail can be seen as:
"Sample House, Sample Road". When I run a script specifying the file is comma delimited I would like it to ignore comma's that are in between speech marks.

Is this possible?

Thanks

Ygor · #2 (**permalink**) 04-05-2004

The only thing that I can suggest would be to change the field separator to something else, e.g. "|"

sed -e ':a' -e 's/\("[^"]*\),\([^"]*"\)/\1~\2/;ta' -e 's/,/|/g' -e 's/~/,/g' file1 > file2

Note: this assumes the file doesn't contain any "~" or "|"

dbrundrett · #3 (**permalink**) 04-05-2004

Thanks for this...

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Combining information from a comma delimited file	vzismann	UNIX for Dummies Questions & Answers	1	08-06-2007 06:20 PM
Parsing comma delimited text file	chengwei	Shell Programming and Scripting	5	02-23-2007 05:38 AM
Loading a comma Delimited file into an Array	grandtheftander	UNIX for Dummies Questions & Answers	2	07-26-2006 01:19 PM
Converting Tab delimited file to Comma delimited file in Unix	charan81	Shell Programming and Scripting	22	01-20-2006 09:24 AM

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


	Powered by