Remove every line with specific string, and also the one above and below it Post: 302902802

Sponsored Content

Top Forums Shell Programming and Scripting Remove every line with specific string, and also the one above and below it Post 302902802 by rbatte1 on Thursday 22nd of May 2014 10:34:44 AM

05-22-2014

Moderator

Assuming no duplication in records, could you get away with two grep commands?:-

Code:

grep -B1 Mamma infile > tempfile
grep -vf tempfile infile > outfile

Have I missed the point in trying to make it too simple?

Code:

# cat input_file                                                  
Where are all amazing Flats
Look At The Great Big White
Hey There Hot Mamma
You Are So hot Baby
I wish You were Mine
Hee How Yee Haw
Hey There Hot Mamma
Wait A minute
Hee Haw Yee Haw
Hey There Hot Mamma
A song Is Here
Make me a List

# grep -B1 Mamma input_file>/tmp/tfile$$                          

# cat /tmp/tfile$$                                                
Look At The Great Big White
Hey There Hot Mamma
--
Hee How Yee Haw
Hey There Hot Mamma
--
Hee Haw Yee Haw
Hey There Hot Mamma

# grep -vf /tmp/tfile$$ input_file      
Where are all amazing Flats
You Are So hot Baby
I wish You were Mine
Wait A minute
A song Is Here
Make me a List

#

Robin

rbatte1

View Public Profile for rbatte1

Visit rbatte1's homepage!

Find all posts by rbatte1

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove Line that contains specific string

I am looking for a way to remove any line in a text file that contains the string "Mac address". I guess you would grep and sed, but I am not sure how to do this. Thanks for you help.

2. UNIX for Dummies Questions & Answers

How to remove columns with specific string?

If I have a data test.txt with 1000 columns such as: id sex gene1 gene2 gene2.dl gene3 gene4 gene4.dl ....... 1 1 AA AT AT TT AT AT ....... 2 1 AG TT TT TA AA AA ....... 3 2 AA AT AT TT AT ...

3. Shell Programming and Scripting

using sed to replace a specific string on a specific line number using variables

using sed to replace a specific string on a specific line number using variables this is where i am at grep -v WARNING output | grep -v spawn | grep -v Passphrase | grep -v Authentication | grep -v '/sbin/tfadmin netguard -C'| grep -v 'NETWORK>' >> output.clean grep -n Destination...

4. Shell Programming and Scripting

remove a specific line in a LARGE file

Hi guys, i have a really big file, and i want to remove a specific line. sed -i '5d' fileThis doesn't really work, it takes a lot of time... The whole script is supposed to remove every word containing less than 5 characters and currently looks like this: #!/bin/bash line="1"...

5. Shell Programming and Scripting

Remove a specific line from grep output string

Dear All I want to search string "1000" from input file and if it found i want remove line that contain 1000 and also remove 3 line above it and 2 line below it. INPUT FILE: BHAT-D 2 aaa ID CODE GS UPDATE MODE LANG MCO MCL NUMPAGES 50 ...

6. UNIX for Dummies Questions & Answers

How to remove a string from a specific column in a file

Hello, A basic query. How can I remove a string from a specific column. For example, remove "abcd" just from column 2 in example file: abcd abcd1 abcd abcd2 abcd abcd3 to get output: abcd 1 abcd 2 abcd 3 Thank you!:)

7. Shell Programming and Scripting

Remove line based on string and put new line with parameter

Hi Folks, I am new to ksh, i have informatica parameter file that i need to update everyday with shell script. i need your help updating this file with new parameters. sample data $$TABLE1_DATE=04-27-2011 $$TABLE2_DATE=04-23-2011 $$TABLE3_DATE=03-19-2011 .......Highligned...

8. Shell Programming and Scripting

Remove line with specific character

HI Input :- Aog:0rt__dev_8 LAAXU24 vs.3 LAA40l0 ** LAAXU241 ** Output :- Aog:0rt__dev_8 LAAXU24 vs.3 Delete the line with **

9. Shell Programming and Scripting

Remove duplicate consecutive lines with specific string

Hello, I'm trying to remove the duplicate consecutive lines with specific string "WARNING". File.txt abc; WARNING 2345 WARNING 2345 WARNING 2345 WARNING 2345 WARNING 2345 bcd; abc; 123 123 123 WARNING 1234 WARNING 2345 WARNING 2345 efgh;

LEARN ABOUT REDHAT

line

line(1)                                                            User Commands                                                           line(1)

NAME

       line - read one line

SYNOPSIS

       line

DESCRIPTION

       The  line utility copies one line (up to and including a new-line) from the standard input and writes it on the standard output. It returns
       an exit status of 1 on EOF and always prints at least a new-line. It is often used within shell files to read from the user's terminal.

EXIT STATUS

       Exit status is:

       0        Successful completion

       >0       End-of-file on input.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE         |      ATTRIBUTE VALUE        |
       +-----------------------------+-----------------------------+
       |Availability                 |SUNWcsu                      |
       +-----------------------------+-----------------------------+

SEE ALSO

       sh(1), read(2), attributes(5)

SunOS 5.10                                                          1 Feb 1995                                                             line(1)