Urgent
Posted: Wed Jan 30, 2008 4:06 am
Hi,
I have data coming in following format:-
1000,
1000,5
1000,52
where ',' denotes decimal...
i want op in following format:-
0000000000000000100000
0000000000000000100050
0000000000000000100052
i.e THE SEPRATOR ',' should be removed and the amt field should be appended by zeroes(i.e if length before ',' is 4 12 zeroes should be appended,if it is 5,11 zeroes should be appened and so on...)
I have data coming in following format:-
1000,
1000,5
1000,52
where ',' denotes decimal...
i want op in following format:-
0000000000000000100000
0000000000000000100050
0000000000000000100052
i.e THE SEPRATOR ',' should be removed and the amt field should be appended by zeroes(i.e if length before ',' is 4 12 zeroes should be appended,if it is 5,11 zeroes should be appened and so on...)