Combining information from a comma delimited file

vzismann · #1 (**permalink**) 08-06-2007

I have a comma delimited file which also contains commas in the text. I was wondering how I can combine one whole column of that file with another file. In essence I'm trying to do an excel vlookup in UNIX to return the information from one column in the comma delimited file(containing text commas also) to the corresponding column in the other file.

I have some UNIX experience but it is not extensive, what is the easiest way to accomplish this?

Thanks!

awk · #2 (**permalink**) 08-06-2007

The way to do this is the Join command (files must be sorted first in column join order).

I would go out of my way to avoid using join.

But do a "man join" to see what it says.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
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
Comma Delimited file	dbrundrett	Shell Programming and Scripting	2	04-05-2004 10:50 AM

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:


	Powered by