Select Record based on First Column

mgirinath · #1 (**permalink**) 07-12-2007

Hi,

I have a file with multiple records...and I have to select records based on first column....here is the sample file...

I01,abc,125,1a2,LBVI02
I01,abc,126,2b5,LBVI02
I02,20070530,254,abc,LLBI01
I02,20070820,111,bvd,NGBI01

I need all records with I01 in first field in one file and all records with I02 in one file...

Shell_Life · #2 (**permalink**) 07-12-2007

Code:

egrep '^I01' input_file > I01_File
egrep '^I02' input_file > I02_File

matrixmadhan · #3 (**permalink**) 07-14-2007

Quote:

Originally Posted by Shell_Life

Code:

egrep '^I01' input_file > I01_File
egrep '^I02' input_file > I02_File

Why do you need egrep when only a single pattern is specified in the regex ?

Shell_Life · #4 (**permalink**) 07-14-2007

Quote:

Originally Posted by matrixmadhan

Why do you need egrep when only a single pattern is specified in the regex ?

Matrixmadhan,
Thanks for verifying my solution.
You are right about it -- for this specific case, I don't really need 'egrep'.

Matrix, I have a habit of always use 'egrep' no matter what.

This comes from the fact that I have had problems trying to use some full
regular expressions with 'grep' -- I had to specify the '-E' option.

Sometimes I found that out after a long headache.

From my last disaster, I promise myself to never use 'grep' again, always 'egrep'.

Matrix, also to reinforce my idea, all three versions of 'grep' in my system all have the same hardlink:

Code:

>ls -li grep egrep fgrep
329785 -r-xr-xr-x  7 root  bin  22.1K Apr 12 09:11 egrep
329785 -r-xr-xr-x  7 root  bin  22.1K Apr 12 09:11 fgrep
329785 -r-xr-xr-x  7 root  bin  22.1K Apr 12 09:11 grep

Which leads me to believe that they are all the same program.

Hope to have answered your question.

Cheers.

reborg · #5 (**permalink**) 07-12-2007

Code:

awk -F, '{file=$1 "_file"; print > file; close (file)}' input_file

matrixmadhan · #6 (**permalink**) 07-14-2007

Code:

awk -F"," '{ print > $1 }' inputfile

reborg · #7 (**permalink**) 07-14-2007

Quote:

Originally Posted by matrixmadhan

Code:

awk -F"," '{ print > $1 }' inputfile

This won't work. It will print all matching records to the file with the same name as $1, the OP wanted the newest record only, which judging by the sample input is the first occurrence only.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
appending spaces to first line based on second record.	ammu	Shell Programming and Scripting	2	11-16-2007 03:35 AM
Select a portion of file based on query	vanand420	Shell Programming and Scripting	14	10-31-2006 04:48 AM
awk to select a column from particular line number	mab_arif16	Shell Programming and Scripting	4	05-08-2006 05:26 AM
Select records based on search criteria on first column	shashi_kiran_v	UNIX for Dummies Questions & Answers	2	12-02-2005 01:49 PM
adding a column at the end of the record	pavan_test	UNIX for Dummies Questions & Answers	2	11-07-2005 11:39 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: