awk script grouping with array

Question

i am trying to execute awk script below on solaris but it's giving error like

awk: syntax error near line 3
awk: bailing out near line 3

where is error can you help me to fix it ?

Input file:

$ cat details.txt
Manager1|sw1
Manager3|sw5
Manager1|sw4
Manager2|sw9
Manager2|sw12
Manager1|sw2
Manager1|sw0

Output required: Group the similar (based on $1) fields($2) together, i.e. group the engineers which are under a particular common manager. i.e. required output:

Manager1|sw1,sw4,sw2,sw0
Manager2|sw9,sw12
Manager3|sw5

Awk solution:

$ awk '
   BEGIN {FS=OFS="|"}
   !A[$1] {A[$1] = $0; next}
   {A[$1] = A[$1] "," $2}
   END {for(i in A) {print A[i]}
}' details.txt

Use tags or to surround your code. is easier sometimes. – Heath Hunnicutt Nov 05 '09 at 06:19 — Heath Hunnicutt, Nov 05 '09 at 06:19
What version of awk? Everything is ok on gnu awk 3.1.5 – RobS Nov 05 '09 at 06:26 — RobS, Nov 05 '09 at 06:26

score 2 · Accepted Answer · answered Nov 05 '09 at 06:27

2

Solaris ... You probably need to run "nawk" instead of "awk".

answered Nov 05 '09 at 06:27

janm

17,976
1
43
61

score 1 · Answer 2 · edited Sep 14 '12 at 12:08

1

You can get the result by running the following script:

awk -F"\t" '{split($0,arr,"|");
    if(arr[1] in dic)  
    {
        dic[arr[1]]=dic[arr[1]]","arr[2];
    }
    else
    {
         dic[arr[1]]=arr[2];
    }
}END{for(i in dic)print i"|"dic[i]}' in.log > "out.log"

edited Sep 14 '12 at 12:08

jonsca

10,218
26
54
62

answered Apr 19 '12 at 10:08

lily

11
1

score 1 · Answer 3 · answered Nov 05 '09 at 06:33

1

in solaris, use nawk or /usr/xpg4/bin/awk

answered Nov 05 '09 at 06:33

ghostdog74

327,991
56
259
343

awk script grouping with array

3 Answers3

Linked