Delete lines between two patterns excluding the other lines containing these pattern


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Delete lines between two patterns excluding the other lines containing these pattern
# 1  
Old 02-28-2020
Delete lines between two patterns excluding the other lines containing these pattern

I would want to only remove the lines between PATTERN1(aaa) and PATTERN2(ccc), excluding the others lines where the patterns matches.

I trying to delete the empty line between PATTERN1(aaa) and PATTERN2(ccc), line 8 in my example...This line will be no all times in same location, that is the reason, why I try to remove it using the 2 patterns.

Essentially it boils down to: "If a blank line is found between aaa and ccc then remove it..

input file
Code:
aaa 409
bbb 201

122 0.98
aaa 1.47
aaa 0.00
aaa 0.00

ccc 0.00
121 0.01
135 1.99

output file
Code:
aaa 409
bbb 201

122 0.98
aaa 1.47
aaa 0.00
aaa 0.00
ccc 0.00
121 0.01
135 1.99

Code:
attempts

Code:
sed  '/aaa/,/ccc/{//p;d;}' file
sed '/aaa/,/ccc/{//!d}' file

Code:
awk '/aaa/{g=1;next}/ccc/{g=0;next}g' file

Thanks in advance

Last edited by jiam912; 02-28-2020 at 01:27 PM..
# 2  
Old 02-28-2020
Not that easy as your start pattern occurs multiple times. For your sample, adapting your first attempt:
Code:
tac file | sed  '/ccc/,/aaa/{/^ *$/d;}' | tac
aaa 409
bbb 201

122 0.98
aaa 1.47
aaa 0.00
aaa 0.00
ccc 0.00
121 0.01
135 1.99

Are multiple end patterns ("ccc") possible?


EDIT: or

Code:
sed -zr 's/(aaa[^\n]*)\n\n([^\n]*ccc)/\1\n\2/' file
aaa 409
bbb 201

122 0.98
aaa 1.47
aaa 0.00
aaa 0.00
ccc 0.00
121 0.01
135 1.99


Last edited by RudiC; 02-28-2020 at 02:17 PM..
This User Gave Thanks to RudiC For This Post:
# 3  
Old 02-28-2020
Hi
GNU extension includes a multiline modifier M,m
Code:
sed -rz 's/(a.*\n)\n+(c.*)/\1\2/m'

--- Post updated at 06:36 ---

the wolves be sated and the sheep intact
Code:
sed -r ':1;N;/\n$/b1;s/(^a.*$)\n+(^c.*$)/\1\n\2/m'

the last example is not true and needs to be fixed

Last edited by nezabudka; 02-28-2020 at 11:37 PM..
This User Gave Thanks to nezabudka For This Post:
# 4  
Old 02-28-2020
Dear RudiC and nezabudka
Thanks a lot for the codes.
# 5  
Old 02-29-2020
I am glad if it was useful, @jiam912
The code has grown a bit, but I could not find another way to get around the buffer size limit
Code:
sed -r ':1;N;/a[^\n]*\n*$/b1;l;s/(^a.*$)\n+(^c.*$)/\1\n\2/m'

The problem was as follows.
If the string starting with 'a' was even line then the code did not work properly.
Add the 'l' command to look at the contents of the buffer (the line marked at the end with a dollar sign)
and add one line to the input file.
Code:
cat file
aaa 409
bbb 201

122 0.98
aaa 1.47
aaa 0.00
aaa 0.00
aaa 1.47

ccc 0.00
121 0.01
135 1.99

Code:
sed -r ':1;N;/\n$/b1;l;s/(^a.*$)\n+(^c.*$)/\1\n\2/m' file
aaa 409\nbbb 201$
aaa 409 
bbb 201 
\n122 0.98$

122 0.98
aaa 1.47\naaa 0.00$
aaa 1.47
aaa 0.00
aaa 0.00\naaa 1.47$
aaa 0.00
aaa 1.47
\nccc 0.00$

ccc 0.00
121 0.01\n135 1.99$
121 0.01
135 1.99

а new version
Code:
sed -r ':1;N;/a[^\n]*\n*$/b1;l;s/(^a.*$)\n+(^c.*$)/\1\n\2/m' file
aaa 409\nbbb 201$
aaa 409 
bbb 201 
\n122 0.98$

122 0.98
aaa 1.47\naaa 0.00\naaa 0.00\naaa 1.47\n\nccc 0.00$
aaa 1.47
aaa 0.00
aaa 0.00
aaa 1.47
ccc 0.00
121 0.01\n135 1.99$
121 0.01
135 1.99


Last edited by nezabudka; 02-29-2020 at 02:52 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to print lines from a files with specific start and end patterns and pick only the last lines?

Hi, I need to print lines which are matching with start pattern "SELECT" and END PATTERN ";" and only select the last "select" statement including the ";" . I have attached sample input file and the desired input should be as: INPUT FORMAT: SELECT ABCD, DEFGH, DFGHJ, JKLMN, AXCVB,... (5 Replies)
Discussion started by: nani2019
5 Replies

2. UNIX for Beginners Questions & Answers

Delete multiple lines between blank lines containing two patterns

Hi all, I'm looking for a way (sed or awk) to delete multiple lines between blank lines containing two patterns ex: user: alpha parameter_1 = 15 parameter_2 = 1 parameter_3 = 0 user: alpha parameter_1 = 15 parameter_2 = 1 parameter_3 = 0 user: alpha parameter_1 = 16... (3 Replies)
Discussion started by: ce9888
3 Replies

3. 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

4. Shell Programming and Scripting

Sed: printing lines AFTER pattern matching EXCLUDING the line containing the pattern

'Hi I'm using the following code to extract the lines(and redirect them to a txt file) after the pattern match. But the output is inclusive of the line with pattern match. Which option is to be used to exclude the line containing the pattern? sed -n '/Conn.*User/,$p' > consumers.txt (11 Replies)
Discussion started by: essem
11 Replies

5. Shell Programming and Scripting

Delete lines and the first pattern between 2 matched patterns

Hi, i need help to delete all the lines between 2 matched patterns and the first pattern must be deleted too. sample as follows: inputfile.txt >kump_1 ........................... ........................... >start_0124 dgfhghgfh fgfdgfh fdgfdh >kump_2 ............................. (7 Replies)
Discussion started by: redse171
7 Replies

6. Shell Programming and Scripting

print lines up to pattern excluding pattern

11 22 33 44 55 66 77 When pattern 55 is met, print upto it, so output is 11 22 33 44 (1 Reply)
Discussion started by: anilcliff
1 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

Delete Lines between the pattern

Hi All, Below is my requirement. Whatever coming in between ' ', needs to delete. Input File Contents: ============== This is nice 'boy' This 'is bad boy.' Got it Expected Output =========== This is nice This Got it (4 Replies)
Discussion started by: susau_79
4 Replies

9. Shell Programming and Scripting

delete lines between patterns

Hi, I've searched in this forum all day long but was not able to find enough codes to help me do a task. The only code that I can come up with is this: sed '/ /,/ /{//p;d;}' inputfile > outputfile I would like to sed/awk/grep a file for two patterns and then delete the lines between... (4 Replies)
Discussion started by: shamushamu
4 Replies

10. Shell Programming and Scripting

Delete lines between two patterns without deleting the second pattern

I want to delete lines like this sed '/FROM_HERE/,/TO_HERE/d' but I would like to *not* delete the second match, i.e. the TO_HERE line. How can I achieve this? Thank you! (1 Reply)
Discussion started by: Ilja
1 Replies
Login or Register to Ask a Question