sed search pattern and delete lines


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sed search pattern and delete lines
# 1  
Old 09-17-2012
sed search pattern and delete lines

Hello,

i have a question.


My problem is that i have a file like:

PHP Code:
TEST
JOHN
ADAM
MICHAEL
SEBASTIAN
ANDY 
i want find for MICHAEL and want delete lines like this:

PHP Code:
TEST
SEBASTIAN
ANDY 
delete 2 lines before pattern and one line after pattern.


i have a solution but it deletes only after find pattern.

PHP Code:
sed '/MICHAEL/,+2d' test.txt 
# 2  
Old 09-17-2012
Using your solution and tac...
Code:
$ cat test.txt
TEST
JOHN
ADAM
MICHAEL
SEBASTIAN
ANDY

$ tac test.txt | sed '/MICHAEL/,+2d' | tac
TEST
SEBASTIAN
ANDY

$

# 3  
Old 09-17-2012
Eightball,
You said you want to delete two lines before the matched line and one line after the matched line, but your example deletes two lines before the match line and the matched line (leaving the line after the match as it was).

The script Ygor provided will provide output matching your example output, but only works on Linux systems (according to the man pages provided on this site, the tac utility is not available on OpenSolaris, FreeBSD, OSX, or POSIX systems).

The following ed script should work on any of these systems:
Code:
#!/bin/ksh
# Usage: edscript pattern input_file output_file
#    Find the 1st line in "input_file" selected by the basic regular
#    expression "BRE"; delet the selected line, two lines before it, and
#    one line after it; and write the update file to "output_file".
ed -s "$2" <<-END
        /$1/-2;.+2d
        w $3
END

save the above script in a file named edscript, make it executable by running the command:
Code:
chmod +x edscript

and then (assuming the input file you specified in your example is named in, execute the command:
Code:
edscript MICHAEL in out

to make the changes suggested by the sample output you provided and save the output in a file named out.
# 4  
Old 09-17-2012
If you want to delete

Code:
TEST 
SEBASTIAN 
ANDY

Use this:
Code:
$ nawk 'BEGIN{FS="\n";RS="";OFS="\n"};{for(i=1;i<=NF;i++){if($(i+3)=="MICHAEL"){$(i+4)="";$(i+5)=""}else print $i}}' filename
JOHN
ADAM
MICHAEL

# 5  
Old 09-18-2012
hi thanks @all
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to delete all lines before a particular pattern when the pattern is defined in a variable?

I have a file Line 1 a Line 22 Line 33 Line 1 b Line 22 Line 1 c Line 4 Line 5 I want to delete all lines before last occurrence of a line which contains something which is defined in a variable. Say a variable var contains 'Line 1', then I need the following in the output. ... (21 Replies)
Discussion started by: Soham
21 Replies

2. Shell Programming and Scripting

sed -- Find pattern -- print remainder -- plus lines up to pattern -- Minus pattern

The intended result should be : PDF converters 'empty line' gpdftext and pdftotext?xml version="1.0"?> xml:space="preserve"><note-content version="0.1" xmlns:/tomboy/link" xmlns:size="http://beatniksoftware.com/tomboy/size">PDF converters gpdftext and pdftotext</note-content>... (9 Replies)
Discussion started by: Klasform
9 Replies

3. Homework & Coursework Questions

sed Multiple Pattern search and delete the line

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I have file which has got the following content sam 123 LD 41 sam 234 kp sam LD 41 kam pu sam LD 61 Now... (1 Reply)
Discussion started by: muchyog
1 Replies

4. Shell Programming and Scripting

Need one liner to search pattern and print everything expect 6 lines from where pattern match made

i need to search for a pattern from a big file and print everything expect the next 6 lines from where the pattern match was made. (8 Replies)
Discussion started by: chidori
8 Replies

5. Shell Programming and Scripting

Sed delete blank lines upto first pattern match

Hi Im trying to do the following in sed. I want to delete any blank line at the start of a file until it matches a pattern and then stops. for example: Input output: I have got it to work within a range of two patterns with the following: sed '/1/,/pattern/{/^]*$/d}' The... (2 Replies)
Discussion started by: duonut
2 Replies

6. Shell Programming and Scripting

sed/awk : how to delete lines based on IP pattern ?

Hi, I would like to delete lines in /etc/hosts on few workstations, basically I want to delete all the lines for a list of machines like this : for HOST in $(cat stations.lst |uniq) do # echo -n "$HOST" if ping -c 1 $HOST > /dev/null 2>&1 then HOSTNAME_val=`rsh $HOST "sed... (3 Replies)
Discussion started by: albator1932
3 Replies

7. Shell Programming and Scripting

sed pattern to delete lines containing a pattern, except the first occurance

Hello sed gurus. I am using ksh on Sun and have a file created by concatenating several other files. All files contain header rows. I just need to keep the first occurrence and remove all other header rows. header for file 1111 2222 3333 header for file 1111 2222 3333 header for file... (8 Replies)
Discussion started by: gary_w
8 Replies

8. Shell Programming and Scripting

copy, then delete lines in file with sed using a pattern

I need to copy lines to a new file from files with sed using a pattern in char postions 1-3. Then after the copy, I need to delete those same lines from the input files. For example, string "ABC" in pos 1-3 (6 Replies)
Discussion started by: laksjfhoius9123
6 Replies

9. Shell Programming and Scripting

sed delete pattern skipping first n lines of file.

I have files of more than 10K lines that I need to delete lines that contain a pattern, but I want to keep the first few lines intact. Can this be done with sed? (7 Replies)
Discussion started by: tkg
7 Replies

10. Shell Programming and Scripting

SED: match pattern & delete matched lines

Hi all, I have the following data in a file x.csv: > ,this is some text here > ,,,,,,,,,,,,,,,,2006/11/16,0.23 > ,,,,,,,,,,,,,,,,2006/12/16,0.88 < ,,,,,,,,,,,,,,,,this shouldnt be deleted I need to use SED to match anything with a > in the line and delete that line, can someone help... (7 Replies)
Discussion started by: not4google
7 Replies
Login or Register to Ask a Question