Print all lines between patterns


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Print all lines between patterns
# 1  
Old 04-25-2013
Print all lines between patterns

Hi Gurus,

I have a requirement where I need to display all lines between 2 patterns except the line where the first pattern in it. I tried the following command using awk but it is printing all lines except the lines where the 2 patterns exist.

Code:
awk '/TRANSF_/{ P=1; next } /Busy/ {exit} P' sess.log

Input file will be like this.

Code:
Thread [TRANSF_1_1_1] created for [the transformation stage] of partition point [SQ_MAIL] has completed.
        Total Run Time = [338.043617] secs
        Total Idle Time = [0.000000] secs
        Busy Percentage = [100.000000]
        Thread work time breakdown:
                EXP_MAIL: 100.000000 percent
Thread [WRITER_1_*_1] created for [the write stage] of partition point [MAIL_OUT] has completed.
        Total Run Time = [278.223948] secs
        Total Idle Time = [278.114421] secs
        Busy Percentage = [0.039367]

I want the output as

Code:
TRANSF
        Total Run Time = [338.043617] secs
        Total Idle Time = [0.000000] secs
        Busy Percentage = [100.000000]

Code:
WRITER
        Total Run Time = [278.223948] secs
        Total Idle Time = [278.114421] secs
        Busy Percentage = [0.039367]

Thanks,
S
# 2  
Old 04-25-2013
Code:
awk -F'[][]' '/^Thread/{gsub(/_.*/,x,$2);print $2;n=0;next}/Busy/{n=1;print;next}!n' file

# 3  
Old 04-25-2013
Code:
sed -n '/^Thread \[/ { s///; s/_.*//; N; N; N; p; }'

Regards,
Alister
This User Gave Thanks to alister For This Post:
# 4  
Old 04-25-2013
Code:
$ sed -n "/^Thread/,/Busy Percentage/ { s/^Thread .//; s/_.*//; p}" input
TRANSF
        Total Run Time = [338.043617] secs
        Total Idle Time = [0.000000] secs
        Busy Percentage = [100.000000]
WRITER
        Total Run Time = [278.223948] secs
        Total Idle Time = [278.114421] secs
        Busy Percentage = [0.039367]

This User Gave Thanks to hanson44 For This Post:
# 5  
Old 04-25-2013
Move the P (print if P is not 0) before the /Busy/ {exit}
This User Gave Thanks to MadeInGermany For This Post:
# 6  
Old 04-25-2013
Thank you.

Quote:
Originally Posted by Yoda
Code:
awk -F'[][]' '/^Thread/{gsub(/_.*/,x,$2);print $2;n=0;next}/Busy/{n=1;print;next}!n' file

Can you please explain the above command?

Thanks,
S
# 7  
Old 04-26-2013
Explanation:
Code:
awk -F'[][]' '                                  # Set [ ] as field separators
        /^Thread/ {                             # Search if record begins with pattern: Thread
                        gsub ( /_.*/, x, $2 )   # Substitute underscore followed by zero or more occurrence of any char in $2 with x (null variable)
                        print $2                # Print $2 (second field)
                        n = 0                   # Set variable n = 0
                        next                    # Skip processing current record
        }

        /Busy/ {                                # Search if record contains pattern: Busy
                        print $0                # Print $0 (whole record)
                        n = 1                   # Set variable n = 1
                        next                    # Skip processing current record
        }

        !n                                      # !n (Print whole record when n = 0, !n == 1 (when true default action is print)
' file

I hope this helps.
This User Gave Thanks to Yoda For This Post:
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. Shell Programming and Scripting

How to print different multiple lines after two patterns?

Hello, I need to print some lines as explained below, TXT example 1111 2222 3333 4444 5555 6666 7777 8888 6666 9999 1111 2222 3333 4444 5555 (8 Replies)
Discussion started by: liuzhencc
8 Replies

3. Shell Programming and Scripting

How to print line if two lines above it matches patterns.?

Hi, I could only find examples to print line before/after a match, but I'd need to print line after two separate lines matching. E.g.: From the below log entry, I would need to print out the 1234. This is from a huge log file, that has a lot of entries with "CLIENT" and "No" entries (+ other... (3 Replies)
Discussion started by: Juha
3 Replies

4. Shell Programming and Scripting

Match 2 different patterns and print the lines

Hi, i have been trying to extract multiple lines based on two different patterns as below:- file1 @jkm|kdo|aas012|192.2.3.1 blablbalablablkabblablabla sjfdsakfjladfjefhaghfagfkafagkjsghfalhfk fhajkhfadjkhfalhflaffajkgfajkghfajkhgfkf jahfjkhflkhalfdhfwearhahfl @jkm|sdf|wud08q|168.2.1.3... (8 Replies)
Discussion started by: redse171
8 Replies

5. Shell Programming and Scripting

Perl : to print the lines between two patterns

Hello experts, I have a text file from which I need to print all the lines between the patterns. Could anyone please help me with the perl script. names.txt ========= Badger Bald Eagle Bandicoot Bangle Tiger Barnacle Barracuda Basilisk Bass Basset Hound Beetle Beluga... (7 Replies)
Discussion started by: scriptscript
7 Replies

6. Shell Programming and Scripting

How to print only lines in between patterns?

Hi, I want to print only lines (green-italic lines) in between first and last strings in column 9. there are different number of lines between each strings. 10 AUGUSTUS exon 4558 4669 . - . 10.g1 10 AUGUSTUS exon 8771 8889 . ... (6 Replies)
Discussion started by: jamo
6 Replies

7. Shell Programming and Scripting

Need to print between patterns AND a few lines before

I need to print out sections (varying numbers of lines) of a file between patterns. That alone is easy enough: sed -n '/START/,/STOP/' I also need the 3 lines BEFORE the start pattern. That alone is easy enough: grep -B3 START But I can't seem to combine the two so that I get everything between the... (2 Replies)
Discussion started by: Finja
2 Replies

8. Shell Programming and Scripting

print lines between 2 matching patterns

Hi Guys, I have file like below, I want to print all lines between test1231233 to its 10 occurrence(till line 41) test1231233 qwe qwe qweq123 test1231233 qwe qwe qweq23 test1231233 qwe qwe qweq123 test1231233 qwe qwe qweq123131 (3 Replies)
Discussion started by: jagnikam
3 Replies

9. Shell Programming and Scripting

Print lines between two repetitive patterns

Hi users I have one file which has number of occurrence of one pattern examples Adjustmenttype,11 xyz 10 dwe 9 abd 13 def 14 Adjustmenttype,11 xyz 24 dwe 34 abd 35 def 11 nmb 12 Adjustmenttype, not eleven .... ... ... (2 Replies)
Discussion started by: eranmoh
2 Replies

10. Shell Programming and Scripting

print lines between two patterns in unix

Detroit Chicago Newyork Battlecreek Jackson Brooklyn How would I print only lines match between Detroit and Brooklyn used awk ? I don't want print Detroit and Brooklyn output should be : Chicago Newyork Battlecreek Jackson Thanks Jhonny (2 Replies)
Discussion started by: jhonnyrip
2 Replies
Login or Register to Ask a Question