converting amount to string 2

[lymi6977]

I need to convert an amount to a fixed string of 15 characters with leading zeros.
I had this working when I did not need to include decimal places. Now, I have to include the full amount.

Example: 1457.70 was 000000000001457

I need it to show as 000000000145770. I must have missed something in a formula, because it keeps dropping the decimal amounts.

Can you help?

 

[Turkbear]

Hi,
In your formula, remove the decimal point first with the
Replace({fieldname}.".","") function, then format the result as desired..






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jmiskey]

lymi6977,

I am trying to do this exact thing (convert a number to a zero padded value). How exactly did you do it? I tried using the Formatting option on the number, and also tried writing a Custom Function (which I have never tried before), and had no luck.

 

[synapsevampire]

I think the usual is something like:

replace(totext({table.field},"000000000"),".","")

This assumes that you are doing the exact same thing and dropping the decimal.

-k

 

[jmiskey]

synapsevampire,
Thanks for replying. I actually saw another post you replied to, and used the logic you used there to come up with this:

ToText({#Total_Check_Amt}*100,"000000000000000")

The only problem is, the original field is a currency field, and I am getting a dollar sign before my value. Can I easily remove it without having to use the Right or Mid functions (it doesn't seem to give me the option to change the format of the calculated field)?

 

[jmiskey]

If not, don't worry about it. I can use the Right function,

Right(ToText({#Total_Check_Amt}*100,"000000000000000"),15)

I just thought I might be overlooking something obvious.

 

[lbass]

You could use:

ToText(tonumber({#Total_Check_Amt})*100,"000000000000000")

-LB

 

[synapsevampire]

You could have just wrapped another REPLACE for the $.

-k