Shell Programming and Scripting

Hi,

I have a file that contains below information:

provider APESD
APESD Annual Turn $67000
Provider
XXXX Annual Turn $92000
Provider FERHG
FERHG Annual Turn $56700
Provider
ABXX Annual Turn $99000

These are just sample rows out of some 5000. I want to create a tabular report as below:

Provider Turnover
--------------------
APESD $67000
FERHG $56700

... ignoring other records because provider name is missing.
Any idea? Can I do it using awk?

regards,
juzz4fun

Here is an approach using awk:

Code:

awk '
        BEGIN {
                print "Provider", "Turnover"
                print "--------", "--------"
        }
        NR%2 && NF==2 {
                p = $2
                printf "%s", p OFS
        }
        !(NR%2) && p {
                print $NF
                p = ""
        }
' OFS='\t' file

Code:

awk 'BEGIN {print "Provider", "Turnover"} /[Pp]rovider/ && NF==2 {getline;print $1,$NF}'
APESD $67000
FERHG $56700

Provider with p and P, typo?

Thanks Jotne and Yoda.
I did understand what Jotne has written and I get required output. 'P' or 'p' is good.

If I understood correct, getline here gets the next record or what?

Yes getline gets the next line and then continue running the awk.
The awk command next, skips whatever its doing and jumps to next line.

So it search for lines that do have Provider and two fields.
Then gets the next line and print filed #1 and last to get the desired value.

Wow. Something new for me...
Thanks again.