Help on parsing record file

2001-12-10 Thread WANG, SHIPING [AG/1000]
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

Re: Help on parsing record file

2001-12-10 Thread John W. Krahn
Shiping Wang wrote: Hi , I have following a record file like this: [snipped data. see below]  What I want output is: CustProdCata 1711 842 1523C 9306152 B 24727 15225 A 46917 9828B 50 4309C For each customer, I only select one