File Reading for a certain string and echo the line before


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting File Reading for a certain string and echo the line before
# 1  
Old 03-09-2012
File Reading for a certain string and echo the line before

Hi Guys,

I have a big file like this. It has cache group line ( the bold lines ) and then followed by 10 status lines showing either Compelte or Failed. This pattern repeats several time. We can assume all the status lines have either Complete or Failed status for that Cache Group line.

I need to find a way to display just the failed cache group lines ( echo of that line ). Here I just want to see one line "call ttcacheautorefreshstatsget('CGOWNER','CG_CLIENT_PLAN');"

Have been struggling for a day but not finding a good solution. Can something like this be achieved using shell scripting or do I have to use perl ?

Hope I didn't confuse in explaining what I want.

Code:
call ttcacheautorefreshstatsget('CGOWNER','CG_CLIENT_NOTE');
< 2284744, 2012-03-08 22:57:11.000000, 24829530, 11422, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Complete >
< 2284744, 2012-03-08 22:57:09.000000, 24827530, 11421, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Complete >
< 2284744, 2012-03-08 22:57:07.000000, 24825530, 11420, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Complete >
< 2284744, 2012-03-08 22:57:05.000000, 24823530, 11419, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Complete >
< 2284744, 2012-03-08 22:57:03.000000, 24821520, 11418, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Complete >
< 2284744, 2012-03-08 22:57:01.000000, 24819520, 11417, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Complete >
< 2284744, 2012-03-08 22:56:59.000000, 24817520, 11416, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Complete >
< 2284744, 2012-03-08 22:56:57.000000, 24815520, 11415, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Complete >
< 2284744, 2012-03-08 22:56:55.000000, 24813520, 11414, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Complete >
< 2284744, 2012-03-08 22:56:53.000000, 24811520, 11413, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Complete >
10 rows found.

call ttcacheautorefreshstatsget('CGOWNER','CG_CLIENT_PLAN');
< 2285336, 2012-03-08 22:57:13.000000, 24830610, 2483, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Failed >
< 2285336, 2012-03-08 22:57:03.000000, 24820610, 2482, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Failed >
< 2285336, 2012-03-08 22:56:53.000000, 24810610, 2481, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Failed >
< 2285336, 2012-03-08 22:56:43.000000, 24800590, 2480, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Failed >
< 2285336, 2012-03-08 22:56:33.000000, 24790580, 2479, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Failed >
< 2285336, 2012-03-08 22:56:23.000000, 24780580, 2478, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Failed >
< 2285336, 2012-03-08 22:56:13.000000, 24770580, 2477, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Failed >
< 2285336, 2012-03-08 22:56:03.000000, 24760580, 2476, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Failed >
< 2285336, 2012-03-08 22:55:53.000000, 24750580, 2475, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Failed >
< 2285336, 2012-03-08 22:55:43.000000, 24740580, 2474, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Failed >
10 rows found.

Thanks in Advance
mkneni

Last edited by Scott; 03-10-2012 at 06:55 AM.. Reason: Code tags, please
# 2  
Old 03-09-2012
I'd write a small awk to read the file and generate the desired output:

Code:
awk '
    $1 == "call" {
        buffer = $0;
        next;
    }

    /Failed/ {
        if( buffer  )
        {
            print buffer;
            buffer = "";
        }
    }
' input-log-file



Prints the 'call' line if any of the lines below it, before the next, are marked failed.
# 3  
Old 03-09-2012
Alternatively try:
Code:
awk '/^call.*Failed/{print $1}' RS= FS='\n' infile


Last edited by Scrutinizer; 03-09-2012 at 01:31 AM..
# 4  
Old 03-09-2012
wow. Thank you both so much.

awk '/^call.*Failed/{print $1}' RS= FS='\n' infile worked good.

Smilie
# 5  
Old 03-09-2012
Just because the problem has been solved does not mean that the fun must come to an end. Smilie
Code:
sed -n '/Failed/{x;//!p;x;}; h' infile

Regards,
Alister
This User Gave Thanks to alister For This Post:
# 6  
Old 03-09-2012
@alister

I tried your code (on a SunOS 5.10 machine), it didn't work ( i have an output as below)

Code:
# awk '/^call.*Failed/{print $1}' RS= FS='\n' my
call ttcacheautorefreshstatsget('CGOWNER','CG_CLIENT_PLAN');
# sed -n '/Failed/{x;//!p;x;}; h' my










#

Scruti's code works fine by the way
# 7  
Old 03-09-2012
Quote:
Originally Posted by ctsgnb
@alister

I tried your code (on a SunOS 5.10 machine), it didn't work ( i have an output as below)
Hi, ctsgnb:

Works fine for me with a BSD sed. Also, the script should be POSIX-compliant.

If you figure out why it fails on your implementation, I'd be interested to know; I'm not familiar with your system's userland.

Regards,
Alister
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Reading a file line by line and print required lines based on pattern

Hi All, i want to write a shell script read below file line by line and want to exclude the lines which contains empty value for MOUNTPOINT field. i am using centos 7 Operating system. want to read below file. # cat /tmp/d5 NAME="/dev/sda" TYPE="disk" SIZE="60G" OWNER="root"... (4 Replies)
Discussion started by: balu1234
4 Replies

2. Shell Programming and Scripting

Echo multi-line string via heredoc syntax

$ cat bashtest #!/usr/local/bin/bash echo <<<"EOF" line1 line2 line3 EOF $ ./bashtest ./bashtest: line 3: line1: command not found ./bashtest: line 4: line2: command not found ./bashtest: line 5: line3: command not found ./bashtest: line 6: EOF: command not found What am i doing... (4 Replies)
Discussion started by: urello
4 Replies

3. Shell Programming and Scripting

Reading line by line from live log file using while loop and considering only those lines start from

Hi, I want to read a live log file line by line and considering those line which start from time stamp; Below code I am using, which read line but throws an exception when comparing line that does not contain error code tail -F /logs/COMMON-ERROR.log | while read myline; do... (2 Replies)
Discussion started by: ketanraut
2 Replies

4. Shell Programming and Scripting

Comparison of fields then increment a counter reading line by line in a file

Hi, i have a scenario were i should compare a few fields from each line then increment a variable based on that. Example file 989878|8999|Y|0|Y|N|V 989878|8999|Y|0|N|N|V 989878|8999|Y|2344|Y|N|V i have 3 conditions to check and increment a variable on every line condition 1 if ( $3... (4 Replies)
Discussion started by: selvankj
4 Replies

5. Shell Programming and Scripting

Reading text file, comparing a value in a line, and placing only part of the line in a variable?

I need some help. I would like to read in a text file. Take a variable such as ROW-D-01, compare it to what's in one line in the text file such as PROD/VM/ROW-D-01 and only input PROD/VM into a variable without the /ROW-D-01. Is this possible? any help is appreciated. (2 Replies)
Discussion started by: xChristopher
2 Replies

6. UNIX for Dummies Questions & Answers

Parsing file, reading each line to variable, evaluating date/time stamp of each line

So, the beginning of my script will cat & grep a file with the output directed to a new file. The data I have in this file needs to be parsed, read and evaluated. Basically, I need to identify the latest date/time stamp and then calculate whether or not it is within 15 minutes of the current... (1 Reply)
Discussion started by: hynesward
1 Replies

7. Shell Programming and Scripting

[Solved] Problem in reading a file line by line till it reaches a white line

So, I want to read line-by-line a text file with unknown number of files.... So: a=1 b=1 while ; do b=`sed -n '$ap' test` a=`expr $a + 1` $here do something with b etc done the problem is that sed does not seem to recognise the $a, even when trying sed -n ' $a p' So, I cannot read... (3 Replies)
Discussion started by: hakermania
3 Replies

8. UNIX for Dummies Questions & Answers

Reading one line from a multiline string

Hi , I have a string which is of multiple line,I have to split the string by reading one line in each iteration and keep it in a string.I am keeping all the file names in side as string returned by the ls command ,I am stocked at the point of spliting the string to segragate each file. ... (4 Replies)
Discussion started by: Deekay.p
4 Replies

9. Shell Programming and Scripting

how to echo the file contents LINE BY LINE

hello, i have a listing (let say ABC) consists of the below: : public database link public synonym role rollback segment : when i run the below for loop, for i in `more ABC` do echo "$i" done it gives me, : public database (4 Replies)
Discussion started by: newbie168
4 Replies
Login or Register to Ask a Question