Joined: 18 Mar 2007 Posts: 44 Location: New Jersey,USA
HI,
I have a requirement , where I need to insert a ACC.NO of customer on all his Address lines.
Ex.
I/P records: Lrecl=080.
Cust.Name occurs in first 20bytes. then Customer no- 15 bytes. After this record I have the address lines of Customer , which is varying(ie) the number of records for address for each customer is different.
I/P:
xxxxxxxxxxxxxxxxxxxx999999999999990
address line1 (---extends till 60 bytes) (last 20 bytes are filler)
address line 2
xxxxxxxxxxxxxxxxxxxx999999999999991
address line1
address line2
address line3
xxxxxxxxxxxxxxxxxxxx999999999999992
address line1
address line2
In ouptut my last 20bytes of address lines should have corresponding Acc.No of that customer.
O/P: LRECL same as I/P
xxxxxxxxxxxxxxxxxxxx999999999999990
address line1 (999999999999990)
address line 2 (999999999999990)
xxxxxxxxxxxxxxxxxxxx999999999999991
address line1 (999999999999991)
address line2 (999999999999991)
address line3 (999999999999991)
xxxxxxxxxxxxxxxxxxxx999999999999992
address line1 (999999999999992)
address line2 (999999999999992)
As The address lines occurences are varying for every customer I could not use Sampling method.
Joined: 18 Mar 2007 Posts: 44 Location: New Jersey,USA
It is identified by the Custno from 21byte. or characters from 21st byte and its following 15 bytes , if found numeric could be easily categorised as ACC / Cust No.
In Address lines It is not possible to have or I did not find the 21-36 bytes all numeric as alpahabets does occur in address lines.