Extracting lines from a canned report

[Belinda Dermody]

We have this canned report running daily but a manager only wants certain data from it. The key lines are
Application : Smart
Call List : XYZABC

Totl Calls:
Avg time

Have attached a sample of the orginal report best to set you terminal to 132 characters. Can any of you guru's come up with a way to extract this information.

[Pete Randall]

James,

Take a look at the attached "Handy One-liners for Sed" (courtesy of Princess Paula). You'll find a section "# print section of file between two regular expressions (inclusive)"
That should do what you ask.


Pete

[Leif Halvarsson_2]

Hi,
Or, if you prefer awk you can try with a reursive function:

function aaa()
{
getline x
if (x !~ /Totl/)
{
print x
aaa()
}
else
print x
}

/Application/ { print; aaa() }

[Belinda Dermody]

Leif, thanks for the response, how would I set up the awk statement to do your example, I just do the basic with awk, awk '{print ....} and other small awk stuff.

[Mark Grant]

I know this looks nasty but...

perl -n -e "next if not /Call List/;while(<>){exit if /Totl Calls/;print;}" testfile

[Graham Cameron_1 · Accepted solution]

Couldn't see any attachment, but if all you want is lines beginning with "Application", lines "Call List" to "Totl Calls", and likes beginning "Avg time", then it's trivial awk.
--
awk '
/^Application/
/^Call List/,/^Totl Calls/
/^Avg time/
' cannedfile
--
Isn't it ?
-- Graham