Hai delete the records - Shell Programming and Scripting

readycpbala · #1 (**permalink**) 02-16-2007

Hai all

i want to grep the particular pattern and move the mathing records to torget file and delete the matching recodrs from source file.

patterns are position based, like

13413432,aaaaaaa,dsfdddddd,34234324,22224555
13413432,aaaaaaa,dsfdddddd,12234324,11222455

i want to move the record which startwith 34 in position 4 or 11 in position 5.
and delete those records from source file also

anbu23 · #2 (**permalink**) 02-16-2007

Code:

awk -F"," ' { 
if ( match($4,"^34" ) || match( $5 ,"^11" ) ) 
	print > "tgt_fl"
else 
	print > "tmp" 
} ' file 
mv tmp file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Script needed to select and delete lower case and mixed case records	abhilash mn	Shell Programming and Scripting	1	03-17-2008 04:00 AM
delete records using line number(NR)	tkbharani	UNIX for Advanced & Expert Users	3	01-31-2008 05:56 AM
Delete Duplicate records from a tilde delimited file	irshadm	Shell Programming and Scripting	5	12-06-2007 01:36 AM
delete records from a file	dsravan	Shell Programming and Scripting	6	09-10-2007 06:49 AM
awk delete blank records	xiamin	UNIX for Dummies Questions & Answers	1	10-31-2001 01:33 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode