Hi , I have following a record file like this:
Customer ID: 1711
* * * No record * * *
Customer ID: 842
Product ID: 716
Category:A
Product ID: 1523
Category:C
Product ID: 753
Category:D
Product ID: 76
Customer ID: 9306
Product ID: 152
Category:B
Product ID: 34762
Category:D
Product ID: 1956
Category:D
Customer ID: 24727
Product ID: 15225
Category:A
Product ID: 9615
Category:D
Customer ID: 46917
Product ID: 20401
Category:A
Product ID: 9828
Category:B
Product ID: 665
Category:C
Product ID: 461
Category:D
Product ID: 1335
Customer ID: 50
Product ID: 19554
Category:A
Product ID: 4309
Category:C
__________________________________________________________
What I want output is:
Cust Prod Cata
1711
842 1523 C
9306 152 B
24727 15225 A
46917 9828 B
50 4309 C
For each customer, I only select one product based on an order of B, C, A,
D.
I thought I might use some kind of data structure like AOA or HOH, but don't
know how. Can anyone give me a help to use perl to handle this case?
Thank you in advance!
Shiping
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
