Hi All,
I have a application which reads from a dat file.I import this into
the database.While exporting this back I want to format the data so
that the alignment is proper.
I have the data in decimals which have to be padded with 0 either to
right or left depending on the digits.((totals to 13 digits)
For some the data is like 58049.859 which is to be padded to make it
as 58049.859000(totally 13 digits)
Some are like 49.859 which is then to be padded as 00049.859000 or
9.85 to be padded as 00009.8500000.
I hope you can understand what I am trying to do here.
As the data is inconsistent,I am not sure how to do this.
I am able to do the padding for a regular number(without decimals) but
confused to do the same for decimals.
Thanks for any help.
Roy