seaching field and getting complete record

mahabunta · #1 (**permalink**) 08-28-2006

hi, I have a file.....

1|3|4|5|6
1|3|4|4|5

now i ahave to search for value 4 in forth field and write that output to a file.

if i do grep 4 file1 both lines are coming to output.

can somebody help me building command.

thanks and regards
sandeep

ranj@chn · #2 (**permalink**) 08-28-2006

Code:

awk -F'|' ' $4=="4" ' inputfilename > outputfilename

You posted a similar question in the other forum. Try to be patient enough for your answer.

mahabunta · #3 (**permalink**) 08-28-2006

thanks,

I have one more doubt...can your command can be used like...

awk -F ":" ' $1=="$file_fmt_id" ' file2 > schema_id_file_test

where file_fmt_id is variable.

thanks and regards

ranj@chn · #4 (**permalink**) 08-28-2006

Change it like this

Code:

awk -F ":"  -v awk_var="$file_fmt_id" ' $1==awk_var ' file2 > schema_id_file_test

mahabunta · #5 (**permalink**) 08-28-2006

thanks a lot...it is working fine

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
how to read record by record from a file in unix	raoscb	UNIX for Dummies Questions & Answers	1	05-16-2008 06:30 AM
splitting a record and adding a record to a file	rsolap	Shell Programming and Scripting	1	08-13-2007 01:58 PM
how to replace field for each record	happyv	Shell Programming and Scripting	12	06-26-2007 07:56 AM
modify a few field of the record information	happyv	Shell Programming and Scripting	11	03-23-2007 01:46 PM
Moving Part of a field to another field using AWK	rjsha1	Shell Programming and Scripting	5	08-04-2006 05: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:


	Powered by