How to remove a particular record from a file? - Shell Programming and Scripting

kanu_pathak · #1 (**permalink**) 07-22-2008

Please tell me the command(s) to remove a particular record from the file and placing the rest of the record in a seperate file.

danmero · #2 (**permalink**) 07-22-2008

Post a sample of your input file in the original format and the exact output you want and please place them within code tags (select the text and click on the # symbol above the edit window).

kanu_pathak · #3 (**permalink**) 07-22-2008

Please find the attached file in text format.

say if i have to remove the NA2 record and NPD record. (this is a portion of file which contains thousands of records). i believe sed pattern matching will work.

danmero · #4 (**permalink**) 07-22-2008

grep solution

Code:

grep -v '^NA2\|^NPD' file > new_file

kanu_pathak · #5 (**permalink**) 07-22-2008

file type:

Code:

NMT000010000100001ENVL,CSP,28#,9X12,KFT,1C                                                        00001
NA20000105500000003081547100100008000000000024.19         000000000000001DZ  000000000024.19  000000000000000  00002
NPD                                                                                                                                            TOP63120                      TOP63120
NP2                                                                                                                                                                                                                                                                                                                                                                                             00000000000000 00000000000000                                                             000                                                                                                                                                                           00000000000000                               00000000000001 00000000000000                                               00000000000000
NMT000010000800001PAD,LGL RL,PRISM,LTR,BE

kanu_pathak · #6 (**permalink**) 07-22-2008

grep is not doing anything.
new_file is still with the same records.
anything with the sed?

BMDan · #7 (**permalink**) 07-22-2008

Code:

grep -vE '^(NPD|NA2)' file > file2

While it's trivial to do this in sed, if there's a way to remove newlines in sed, I've never found it. You could always try piping it into Perl:

Code:

cat file | perl -ne 'print unless /^(NPD|NA2)/;'

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
Remove First and Last Record from a file	ravikuc	UNIX for Dummies Questions & Answers	1	10-11-2007 03:35 AM
splitting a record and adding a record to a file	rsolap	Shell Programming and Scripting	1	08-13-2007 01:58 PM
command to remove last record on file	mheinen	UNIX for Dummies Questions & Answers	4	01-09-2007 03:39 PM
remove duplicated xml record in a file under unix	happyv	Shell Programming and Scripting	8	09-20-2006 01:36 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: