formatting help

[billbose]

Hi awk experts,

I have a file with some duplicate first fields like as follows:

shop | greg | 21
shop | bill | 23
work | jane | 26

I want the desired o/p to be as:
shop | greg bill | 21
| | 23
work | jane | 26

Could somebody help me?
Note: the pipes are just field seperators, ignore them.
TIA

Regards,
Bill

 

[gregor weertman]

awk -F"|" '{
if( arr[ $1] == "&quot {
ii++
carr[ ii] = $1
arr[ $1] = $0
}
else {
split( arr[ $1], art)
art[2] = art[2] "" $2
arr[ $1] = art[1] "|" art[2] "|" art[3]
}
}
END{
for( jj = 1; jj <= ii; jj++) print arr[ (carr[ jj])]}' Yourfile

I hope it works on solaris nawk.
I use HPUX.

Succes Bill

Gregor.Weertman@mailcity.com