FORMAT> issue

[mightycpa]

I need to format any positive number to a length of 15, always including two decimal places, with no additional adornments, like this:

123456789012.45

a) What is going on with this code?

Code: Select all

Let>v_sumdr=789012.45
//Format>%.2n,%v_sumdr%,v_sum1
Format>%15d,%v_sumdr%,v_sum2
//v_sum2 yields a padded zero
MessageModal>%v_sum2%   

b) can FORMAT do the job, or do I have to write my own function?

[Marcus Tettmar]

Don't think Format will do what you want. I'm a little unsure what you want to do. Does your source data already have two decimal places? Do you just mean you want to prepad the number with zeros? i.e. if you start with 709012.45 are you wanting to end up with 0000000709012.45 ?

If so you could just do:

Code: Select all

Let>num_in=709012.45
VBEval>Right("00000000000000" & "%num_in%",15),num_out

Of course any input that is larger than 15 digits will be truncated, losing the significant digits.

Hence why I need to ask what you are trying to achieve.

[mightycpa]

No, I need to prepad with spaces, and no, the amount does not always have two decimals. It might be 1.1 or 1234

In the end, I need it to be a string of length 15, with two decimals on the end.

I had already come to the conclusion that FORMAT wouldn't help, so I wrote something that works.

As to "what is going on with this code?" again, I should have been more clear, but run this code:

Code: Select all

Let>v_sumdr=789012.45
//Format>%.2n,%v_sumdr%,v_sum1
Format>%15d,%v_sumdr%,v_sum2
//v_sum2 yields a padded zero
MessageModal>%v_sum2%

and see if you are as surprised by the results as I am.

[JRL]

Doesn't seem to like the decimal point.

Code: Select all

Let>v_sumdr=789012
//Format>%.2n,%v_sumdr%,v_sum1
Format>%15d,%v_sumdr%,v_sum2
//v_sum2 yields a padded zero
MessageModal>%v_sum2%

[mightycpa]

Good catch, JRL!