grouping and aggregating

[Guest_imported]

Hi all,
Got a sed pre-processed file like:

RS0ISS 12:14:47
RS0ISS 12:17:01
RS0ISS 15:09:10
F5ZNJ 07:08:59
F5ZNJ 09:33:06
...etc

and would like to have the following:

RS0ISS 12:14:47,12:17:01,15:09:10
F5ZNJ 07:08:59,09:33:06
...etc

pse, any clues, tnx in advance.

 

[vgersh99]

BEGIN {
OFS=","
}

{
arr[$1] = ($1 in arr) ? arr[$1] OFS $2 : $2

}

END {
for (i in arr)
printf("%s%s%s\n", i, FS, arr);

}

 

[Guest_imported]

Great !
it works fine and also save plenty of time for the rest of my project.
I really need to find a good book about this powerful AWK language.
Tnx again

 

[gregor weertman]

vgersh99,

One vote from me.

I see now my awk knowledge is humble.
I'm finely going to buy a book now.

Regards Gregor. Gregor.Weertman@mailcity.com

 

[CaKiwi]

I recommend Sed & Awk by Dale Dougherty & Arnold Robbins from O'Reilly & Assoc CaKiwi