Dataport export and decimals

Phenno · 2007-04-20

Hello ppl.

Does anybody knows how to export decimal into TXT file (via dataport) which has 2 decimal places mandatory?

By using FORMAT command I can only make it to display (or not to display) decimals places at all but cannot force it to display 2 decimal places even if they are zero value.

for example:
in my txt file i have to have:
1234,00
1234,80

But I get (respectively):
1234
1234,8

So, how can I format decimal number to always print out with 2 decimal places?

On reports and labels (table fields on forms) there is a property for formating such fields (2:2 is exactly what I need) but through code I am not able to do it.

David_Cox · 2007-04-20

Look at the format in the help files and type decimal, there is a lot you can do!

you need to put the decimal value into a textVariable, look at the codeunit 8 there is a function there FormatCellasText which will show how to do this as well but for now!

ValueAsText := FORMAT(Value,0,'<Precision,2:2><Standard Format,0>');

Phenno · 2007-04-20

David Cox wrote:

Look at the format in the help files and type decimal, there is a lot you can do!

you need to put the decimal value into a textVariable, look at the codeunit 8 there is a function there FormatCellasText which will show how to do this as well but for now!

ValueAsText := FORMAT(Value,0,'<Precision,2:2><Standard Format,0>');

Thank you very much... Actually, just a minut ago I found a same solution (in help file too).

Anyhow, thnx!

billhwang2008 · 2012-08-29

I'd like to say thanks for this post, it just helped me.

Howdy, Stranger!

Quick Links

Categories

Dataport export and decimals

Answers