DSXchange

Hi,
I have a text file as output. The data looks like this

60 AA 1234 95

It should look like

60 AA 1234 0000095

I specified the last column as integer and I can get the output as 0000095 but there is an extra dot(.) at the end. I cannot convert it into character because the zeros will be removed and it will be only 95. How can I remove the . at the end and still have my data padded by 0?

Thanks

You need to specify the data type as string if you want leading zeroes and no decimal placeholder.

... and then pad it yourself.