Data Format

dsconultant · Post by **dsconultant** » Sat Dec 19, 2009 2:37 pm

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

ray.wurlod · Post by **ray.wurlod** » Sat Dec 19, 2009 3:12 pm

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

chulett · Post by **chulett** » Sat Dec 19, 2009 4:48 pm

... and then pad it yourself.