Need an help in sort. My i/p file is having below structure:
I/P:
0000010005750120140700000006350{130322NNATLANTA
000001000575 Y00000000000123000001
0000010005750120136800000014050{130307NNCORPORATION
000001000575 Y00000000140500000001
need to create a report in below format where the date is present in the detail record and the other informations such as total number of records and amount are in triler record.
O/P:
Code: Select all
CURRENT MONTH
DAY TOTAL AMOUNT NO OF RECORDS
-----------------------------------------------------------------------------------------------
22 123 1
07 1405 1
TOTAL 1525 2
Thanks,