Set format variable

[intervigilium]

In the script i convert some strings to a number, where " . " is the decimalseperator.

That works fine.

If i want to calculate with it, it transforms back to " ,  " as decimalseperator. Tried anything without succes, should be simple i think

In script from string to number i used:

    Num#(X_LL,'#.#', '.' , ',') as longitude,

Num#(Y_LL,'#.#', '.' , ',') as latitude

I works fine.

But after calculating the median it comes with an " , "

var_mid_lat=median(latitude);

If i add a textbox with the following code:

=num#((var_mid_lat), '#.##', '.' , ',')

It gives back the correct value.

How to combine both so the variable format is correct?

For example i would expect something like:

in the variable:

var_mid_lat     = '=num#(median(latitude),'#.#' , '.' , ',' )';

But this is not working, wrong syntax

[Anil_Babu_Samineni]

May be doing Replace

LET var_mid_lat     = num#(Replace(median(latitude),'.' , ',' ),'#.#');

[vishsaggi · Accepted solution]

In your main script near environment set variables change this like below: And run your script again

ThousandSep as Comma and DecimalSep as Dot. .

SET ThousandSep=',';

SET DecimalSep='.';

[intervigilium]

Hi Anil and Vishwarath,

Thanks for your help!

The answer of Vishwarath did solve the problem. The syntax of your solution Anil gives an error (dont know why). Next time i will add the excel, so you can reload the script.

THanks again for all your help!!