counting and moving groupsby malaga (Pilgrim)
|on Jan 23, 2005 at 20:00 UTC
malaga has asked for the wisdom of the Perl Monks concerning the following question:
I've been trying to figure out the logic on this one and i can't quite get there. i don't know if perl can handle it alone of if i need mysql. the data does not need to be stored - it's just a list clean up for a specific one time purpose. so: i'm stuck on which tools to use and the logic in general - any help is appreciated.
I have 2 csv tables with a common id key.
One is account name and information so each record is unique.
The other is purchase information, so there are as many as 40 records with the same id key.
Accounts have 1 to 40 purchases at the moment but this could grow.
The end result is to have 5 purcases per line per account, then skip to the next line. like this:
Thanks for your time!