Awk Script that implements a report writer Post: 302474597

Sponsored Content

Homework and Emergencies Homework & Coursework Questions Awk Script that implements a report writer Post 302474597 by birei on Wednesday 24th of November 2010 06:11:24 PM

11-24-2010

Registered User

Hi,

I get confused because your explanation of fields doesn't match with the input field provided.

Product lines have 4 fields, associate lines have only 3 fields, and the third one is the position, not the 'last name' (�?). The sales lines have 5 fields, and I think the date is fourth, the third one is the quantity and the second one the product id.

Correct me if i am wrong but seems confused for me. Even so I have made an attemp, test it if can be useful for you:

Code:

$ awk --version | sed '1q'
GNU Awk 3.1.8
$ cat report
BEGIN {
    ## Field separator.
    FS=":";

    ## Header.
    printf("%s\n", "Lazy Acres, Inc.");
    printf("%s\n", "2009 Sales Associates Ranking");
    printf("%-30s %-20s %20s\n", "Name", "Position", "Sales amount");
    for (i = 0; i < 72; i++) {
    printf("%c", "=");
    }
    print;
}

## Associates lines.
## $1 -> Associate ID.
## $2 -> First name.
## $3 -> Position.
NF == 3 {    
    assoc[$1] = $2 ":" $3;
}

## Product lines.
## $1 -> Product ID.
## $4 -> Price.
NF == 4 {
    product[$1] = $4;
}

## Sales lines.
## $2 -> Product ID.
## $3 -> Quantity.
## $4 -> Date.
NF == 5 && $4 ~ /2009/ {
    if ($2 in product) { sales[assoc[$NF]] += $3 * product[$2]; }
}

END {
    ## Sorted associates names.
    asorti(sales, salesSortedI);
    ## Reverse sorted sales (numeric numbers from smallest to biggest).
    asort(sales, salesSortedD);

    j = 0;
    for (i = length(sales); i > 0; i--) {
    j++;
    match(salesSortedI[j], /(.*):(.*)/, a);
    printf("%-30s %-20s %20s\n", a[1], a[2], salesSortedD[i]);
    }
}
$ awk -f report inputfile
Lazy Acres, Inc.
2009 Sales Associates Ranking
Name                           Position                     Sales amount
========================================================================
Buck, Fast                     Stock Boy                         2398.89
Doe, John                      Clerk                             1059.67
Lindon, Rosemary               Producer                           139.76
Miller, Dennis                 Comedian                           134.01
Rush, George                   Salesman                               31
Worker, Susan                  Manager                              8.91

Regards,
Birei

birei

View Public Profile for birei

Find all posts by birei

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Share CD-Writer

Hi, guys ! I have a server that runs FreeBSD 5.3 and on that server a have a CD-Writer used for backup. The question is, does anybody know how can I share this CD-Writer ? I want to be able to write CDs from another computer, without transfering all the data to the server and after that use all...

2. UNIX for Advanced & Expert Users

Probleme With DVD Writer

I Use mkcd for save same directories into DVD, But the commande not complete succefuly mkcd -r directorie_i_whish_save -d /dev/cd1 please it is very urgent thank you :confused: :confused:

3. AIX

Probleme with DVD Writer

I can write into DVD? I have USE "MKCD" command mkcd -r directorie -d /dev/cd1 please help me it s urgent

4. Shell Programming and Scripting

Awk Script for generating a report

Hi all, I have a log file of the below format. 20081016:000042 asdflasjdf asljfljs asdflasjf safjl 20081016:000229 /lask/ajlsdf/askdfjsa 20081016:000229 /lashflas /askdfaslj hsfhsahf 20081016:000304 lasflasj ashfashd 20081016:000304 lajfasdf ashfashdfhs I need to generate a...

5. Homework & Coursework Questions

How Unix implements virtual memory?

Use and complete the template provided. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: The key to using memory most efficiently is virtual memory management. Consider both Windows and UNIX operating systems. Compare and contrast how each...

6. HP-UX

How Unix implements virtual memory?

Hello! just wanna ask if how UNIX implements virtual memory, and how it handles page faults, working sets, page sizes and how it reconciles thrashing issues? if you know some sources where I can have some idea, just post it here. thx

7. Homework & Coursework Questions