extract a field by logic

ChicagoBlues · #1 (**permalink**) 01-27-2009

below are the contents of file 'tmp.out':

2|34|534|
1|355|54|
1|443|34|
3|43|768|
3|7|887|
1|9|990|

How do I extract the 2nd and 3rd columns of file 'tmp.out' only when the first column equals '1'.

Note that this file will be huge; atleast 5million+ rows, so I want to avoid looping over this file.

Thanks,

- CB

Ikon · #2 (**permalink**) 01-27-2009

Code:

 grep '^1|' test.log | awk -F '|' '{ print $2 "|" $3 }'

joeyg · #3 (**permalink**) 01-27-2009

Code:

> cat file150
2|34|534|
1|355|54|
1|443|34|
3|43|768|
3|7|887|
1|9|990|
> awk -F"|" '$1=="1"{print $2"|"$3}' file150
355|54
443|34
9|990

ChicagoBlues · #4 (**permalink**) 01-27-2009

Okay, so what if I want to search for that '1' in the sixth column, and extract 8 and 9th columns.

- CB

ChicagoBlues · #5 (**permalink**) 01-27-2009

got it...

awk -F"|" '$6=="1"{print $8"|"$9}' tmp.out

where the tmp.out file has 9 columns.

Thx.

- CB

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
need to extract field of characters in a line	jansat	Shell Programming and Scripting	3	05-22-2008 10:44 AM
How to extract field from variable more efective	pp56825	Shell Programming and Scripting	11	01-19-2008 10:34 AM
logic needed to extract lines	ganapati	UNIX for Dummies Questions & Answers	2	01-10-2008 07:18 AM
Extract Part of string from 3rd field $3 using AWK	stakuri	Shell Programming and Scripting	4	10-10-2007 01:28 PM
Trying to extract a field from /etc/passwd file..	xBuRnTx	UNIX for Dummies Questions & Answers	2	10-05-2005 03:45 AM

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