I have a requirement where the incoming message is a .csv file
80000073,2,,05/14/2012,2153.91
80000073,3,,05/25/2012,184.56
80000073,40,,07/20/2012,1911.69
80000073,500,,07/26/2012,4437.71
I have to convert it into a text file
80000073 00000000550080814000000482782
80000073 00000359460022814000000000102
80000073 00000359470022814000000001427
80000073 00000364540052314000000001700
They are positional
I have to intend with the space in the first filed which i can do with the the String function. But I am not sure how can I do with the second field to add zeros in front of the fields. Because the length of the 2nd field in output is 10. So if the incoming is 2 the output should be 0000000002, if it is 200 then 0000000200. I am not sure how to add those zeros in front.
Thanks