column extract help

cvm · #1 (**permalink**) 04-24-2008

A, B, C, D, E, F, G
1, 12, 13, 100, 12345, 432, 142324
2, 432, 435, 4543, 543, 5, 436543
324, 5, 543, 4365, 43643, 436543, 436543

how to extract particular column when i need of column of A or B or C i need it to redirect into a new file.

aigles · #2 (**permalink**) 04-24-2008

If you want to get columns by column number (cols 2 and 4 for example):

Code:

cut -d, -f2,4 inputfile

If you want to specify column id (cols " B" and " D" for example) :

Code:

awk -F, '
NR==1 {
   nbids = split(cols, ids, FS);
   for (i=1; i<=NF; i++)
     colid[$i] = i;
   for (i=1; i<=nbids; i++)
      if (ids[i] in colid)
         colsnum[++nbcols] = colid[ids[i]]
}
{
   out = "";
   for (i=1; i<=nbcols; i++)
      out = out FS $(colsnum[i]);
   print substr(out, 2);
}
' cols=" B, D" inputfile

Jean-Pierre.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to extract first column with a specific character	selamba_warrior	Shell Programming and Scripting	3	05-22-2008 05:14 AM
How to extract only first column from the file	selamba_warrior	Shell Programming and Scripting	11	05-21-2008 02:52 AM
How to extract a column from two different files in AWK?	solracq	Shell Programming and Scripting	7	04-29-2008 06:21 AM
Extract column data from File	sudheshnaiyer	UNIX for Dummies Questions & Answers	3	10-11-2007 09:52 PM
extract column based on name	t27	UNIX for Dummies Questions & Answers	3	08-29-2007 01:04 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:


	Powered by