posted 16 years ago
Hi All!
let me first tell,what i need.
please look into the records carefully.
each cutomer have multiple records ,they are identified by their calling number.
i am giving follow records for example.
CustomerRef|EventType|CallInfo|Destination No/MRC Amount|StartTime|End Time
CUST001|USAGE||0044234567892|20071101081020|20071101084012|
CUST001|USAGE|4026959526|0015137233456|20071101200240|20071101200730|
CUST009|MRC|Montly Rent|119|20071101000000|20071130000000|
CUST010|MRC|Montly Rent|119|20071001000000|20071031000000|
CUST006|USAGE|4026959526|0015137233456|20071103161419|20071103161806|
CUST006|USAGE|4026959526|00914466557878|20071102121007|20071102121059|
I need to format this records.and i want to separate each customer records separately.and i want to store each customer details separetely.
Pls help me out in this.
Thanks in advance.
Boss.