Re^2: Perl hashes: is there some way of adding more data to the value associated with an existing key?

[mertserger]

in reply to Re: Perl hashes: is there some way of adding more data to the value associated with an existing key?
in thread Perl hashes: is there some way of adding more data to the value associated with an existing key?

Thanks to everyone for their replies.

As Daniel pointed out, the best way was to do this in the SQL, but I wasn't sure if you could. I have yet to find a website for SQL monks! However with Daniel's pointer I found the useful Oracle function wm_concat which does what I want to data and which I never knew about before.

You learn something every day and as always: there is more than one way to do things.

[onelesd]

TMTOWTDI: I like to think of awk as baby perl - a really fast baby.

awk '{
  seen[$1] = $2","seen[$1] ;
}
END {
  for (key in seen) {
    print key" "seen[key] ;
  }
}
' /your/file.txt > /your/newfile.txt