How to cut multiple columns at a time.
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 |
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 |
All times are GMT -5. The time now is 11:18 PM. |