i am trying to implement the saveasasciiformatted function.
we need to export the contents of our datawindow to a ; separated file.
this works just fine, except for the decimals.
we would like to force the decimals to be exported as 9999999999.99999 where the . is the decimal separator.
We are located in Europe so our users are using the , comma as decimal separator.
So in the datawindow we "see" the value
123456789,12345 => this should be exported as 123456789.12345
1234 => this should be exported as 1234.00000
0,123 => this should be exported as 0.123
Bare in mind , i don't want to be reading and processing line by line, unless there's no alternative.
i found the dw_1.SetFormat() function which allows me to change the format just before the .saveasciiformattedtext function call.
Big question is now , to which format i must set my decimal columns to obtain what i want please ?