how to read the column and print the values under that column - Shell Programming and Scripting

gemini106 · #1 (**permalink**) 03-27-2008

hi all

,

how to read the column and print the values under that column ...??

file1 have something like this

cat file1
=======
column1, column2,date,column3,column4.....
1, 23 , 12/02/2008,......
2, 45, 14/05/2008,.....
3, 56, 16/03/2008,.....

cat file2
=======
column1,date,column3,column4.....
1,12/02/2008, 34,......
2,14/05/2008,56, .....
3,16/03/2008,78......

i need output like this

cat file1
=====
date
12/02/2008
14/05/2008
16/03/2008

cat file2
=====
date
12/02/2008
14/05/2008
16/03/2008

only date filed column values ...

pls help ...

thx in advance..

Shivdatta · #2 (**permalink**) 03-27-2008

Code:

awk -F"," '{print $3}'file1

Similarly for file2...

awk -F"," '{print $2}'file2

The o/p will appear on the screen....redirect to a file as per ur requirment

gemini106 · #3 (**permalink**) 03-27-2008

thx for respond,
this i knew , but i need a script to handle that column date

date column maybe $1 , $2 ,$3, $4.....

thx,

Shivdatta · #4 (**permalink**) 03-28-2008

Hope this helps

Code:

awk -F"," '/date/{}{print $(NF-1)}' testfile

Please ignore this post

era · #5 (**permalink**) 03-28-2008

Actually you are on the right track there.

Code:

awk -F, 'NR==1{for (i=0; i<=NF; i++) { if ($i == "date") break; } }
{ print $i }'

Shivdatta · #6 (**permalink**) 03-28-2008

Meanwhile i was trying...heres one approach...
but i guess ...not a gd one

Code:

awk -F"|" '{ 
	    split ($0,a,",")
	    for (i=0 ;i<=NF;i++) 
		{
		if (a[i] == "date")
		val =i 
		}
	   } { print $val}'

gemini106 · #7 (**permalink**) 03-28-2008

Thanks 2 all

, its working fine...

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
replace the column values.	charandevu	Shell Programming and Scripting	6	04-01-2008 11:21 PM
How to check Null values in a file column by column if columns are Not NULLs	Mandab	Shell Programming and Scripting	7	03-15-2008 05:57 AM
Need help with switching field/column values	sonyd8	Shell Programming and Scripting	7	02-12-2008 09:10 PM
replace a column values with the first value in column	sumeet	UNIX for Advanced & Expert Users	3	02-06-2007 09:13 AM
Capturing the values of column in one parameter	mgirinath	Shell Programming and Scripting	5	06-14-2006 10:43 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode