parse text file using awk

Question

I am looking to parse a space delimited input text file using awk. The column code can have more than one row for each group. I would greatly appreciate any help with this.

LOCATION
SHANNON

GROUP  NUM  SWITCH  CODE HEX
0      4     OFF    1    3
1      13    ON     2    4      
                    8
                    14

LOCATION
LOUTH

GROUP  NUM  SWITCH  CODE HEX 
0      1    OFF     1    4
1      2    ON      0    F
                    2

Desired output file

LOCATION GROUP  NUM  SWITCH  CODE HEX
SHANNON   0     4    OFF     1    3
SHANNON   1     13   ON      2    4  
SHANNON   1     13   ON      8    4  
SHANNON   1     13   ON      14   4 
LOUTH     0     1    OFF     1    4
LOUTH     1     2    ON      0    F
LOUTH     1     2    ON      2    F

awk seems to be very quick and does not use any other programs — Santosh Pillai
– Santosh Pillai, Commented Sep 17, 2013 at 14:48
I was using vba for parsing, in comparison awk is much quicker in performing similar operations. Do you have any other way to suggest? — Santosh Pillai
– Santosh Pillai, Commented Sep 17, 2013 at 15:04
Awk is powerful but has limits though and when it tries to comprehend for its limits, that would be the point where it becomes slow or code bulky. — konsolebox
– konsolebox, Commented Sep 17, 2013 at 15:15
@SantoshPillai When other variables are not present, it's only the code that code exist right? — konsolebox
– konsolebox, Commented Sep 17, 2013 at 15:17

konsolebox · Accepted Answer · 2013-09-17 15:26:04Z

5

#!/usr/bin/awk -f

BEGIN {
    # You can customize this to change your output layout based on your preference.
    format = "%-10s%-7s%-5s%-8s%-5s%-3s\n"
    printf format, "LOCATION", "GROUP", "NUM", "SWITCH", "CODE", "HEX"
}
++i==2{
    l = $1
}
i>4{
    if (/^[[:blank:]]*$/) {
        i = 0
    } else if (NF > 1) {
        printf format, l, $1, $2, $3, $4, $5
        p1=$1; p2=$2; p3=$3; p5=$5
    } else {

        printf format, l, p1, p2, p3, $1, p5
    }
}

Run with:

awk -f script.awk file

Output:

LOCATION  GROUP  NUM  SWITCH  CODE HEX
SHANNON   0      4    OFF     1    3  
SHANNON   1      13   ON      2    4  
SHANNON   1      13   ON      8    4  
SHANNON   1      13   ON      14   4  
LOUTH     0      1    OFF     1    4  
LOUTH     1      2    ON      0    F  
LOUTH     1      2    ON      2    F

edited Sep 17, 2013 at 15:26

answered Sep 17, 2013 at 15:09

konsolebox

76.3k13 gold badges110 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

konsolebox Over a year ago

@SantoshPillai Please check.

Santosh Pillai Over a year ago

Works great. Perfect :)

Collectives™ on Stack Overflow

parse text file using awk

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related