CODEWITHSUNDEEP
awk
rajiv
rajiv

Reputation: 19

parsing string using awk or sed

My file content is like below:

20 name:abc addr:203.45.247.247/255.255.255.255 WDW-THRESH:12 BW-OUT:10000000bps BW-IN:15000000bps STATSDEVICE:test247 STATS:Enabled (4447794/0) <IN OUT>
25 name:xyz160 addr:203.45.233.160/255.255.255.224 STATSDEVICE:test160 STATS:Enabled priority:pass-thru (1223803328/0) <IN OUT>
37 name:testgrp2 <B> WDW-THRESH:8 BW-BOTH:192000bps STATSDEVICE:econetgrp2 STATS:Enabled (0/0) <Group> START:NNNNNNN-255-0 STOP:NNNNNNN-255-0
62 name:blahblahl54 addr:203.45.225.54/255.255.255.255 WDW-THRESH:5 BWLINK:cbb256 BW-BOTH:256000bps STATSDEVICE:hellol54 STATS:Enabled (346918/77) <IN OUT>

Using the below awk script:

awk -F"[: ]" '{out=$1; for(i=2;i<=NF;i++)if($i~/bps/){sub("bps","",$i);out=out" "$i} print out;out=""}' input.txt

I got this output:

20 10000000 15000000
25
37 192000
62 256000

But I expect this output:

20  15000000 10000000
25
37 192000
62 256000

Upvotes: 1

Views: 415

Answers (2)

Arcadien
Arcadien

Reputation: 2278

invert the loop

awk -F"[: ]" '{out=$1; for(i=NF;i >1;i--)if($i~/bps/){sub("bps","",$i);out=out" "$i} print out;out=""}' file.txt

there is no need to check $0 and $1 in the loop. $0 is the whole line and $1 is already included in the output

Upvotes: 4

Dennis Williamson
Dennis Williamson

Reputation: 360085

Perhaps "BW-IN" and "BW-OUT" don't always appear in the same order.

awk -F"[: ]" '
    {
        out = $1;
        for (i = 2; i <= NF; i++) {
            if ($i ~ /bps/) {
                sub("bps", "", $i);
                if (! flag) {
                    out = out " " $i save
                } else {
                    flag = 0
                    save = " " $i
                }
            }
            if ($i == "BW-OUT") {
                flag = 1
            }
        }
        print out;
        out = save = ""
    }
' input.txt

Upvotes: 0

Related Questions