Utilities for CSV

Corona688 · #1 (**permalink**) 04-16-2009

I'd like to be able to do something like 'select column_a column_c column_b from file.csv'. Scripting it probably wouldn't be too extraordinarily difficult but I'd rather not reinvent the wheel if someone's built a better one already.

vgersh99 · #2 (**permalink**) 04-16-2009

A full-blown SQL or just a simple 'select' (with configurable column names/numbers)?

Corona688 · #3 (**permalink**) 04-17-2009

Just a simple select to pick and rearrange columns.

vgersh99 · #4 (**permalink**) 04-17-2009

something along these lines (but I bet you meant something more elaborate):

nawk -v select='1,5,3' -f csv.awk csv.csv

csv.awk:

Code:

BEGIN {
   FS=OFS=","
   selN=split(select, selA, FS)
}
{
  for(i=1; i<=selN; i++)
     printf("%s%c", $selA[i], (i==selN)?ORS:OFS)
}

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
utilities	subhendu81	UNIX for Advanced & Expert Users	5	03-09-2009 06:26 AM
how to run utilities	hershey101	UNIX for Dummies Questions & Answers	1	06-20-2008 01:27 AM
bc and wc utilities???	skyineyes	UNIX for Dummies Questions & Answers	6	05-29-2008 12:46 PM
Awk Utilities	jyo123.jyothi	Shell Programming and Scripting	10	05-08-2008 05:45 AM
Awk Utilities	jyo123.jyothi	Oracle Updates (RSS)	0	05-08-2008 04:19 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