[SOLVED] How to cut multiple columns at a time.

secondchanti · 08-18-2010, 10:14 AM

Friends,

I am having a souce file (say SOURCEFILE) as below with 5 columns and many rows.

pol name status loan address
123 aaa 21 100 RJY
234 bbb 31 200 RMY
345 ccc 21 300 SJY
456 ddd 41 400 pqr

i want to compare the file (say COMPAREFILE ) which is below :

123
345

I need the following output file (sayOUTPUTFILE) as below :
( ie for file COMPAREFILE i need column 2, column 4 ie name and loan from source file )

ie output file required is to be like below :
123 aaa 100
345 ccc 400

Till now iam using the following method.
1. cutting column 2nd column
2. again cutting 4th column
3. in third, step merging the 2nd and 4 th column.

Friends, pl tell me method of writting single line command or any awk programme to do this in one step.

Thanks

Rao

I need output file (say OUTPUTFILE) as below

grail · 08-18-2010, 10:30 AM

If its delimetered nicely then awk is your friend

Something like:

Code:

awk '{if(FNR == NR)a[$0]++;else if($1 in a)print $1,$2,$4}' COMPAREFILE SOURCEFILE > OUTPUTFILE