Number format decimal seperator and thousand seperator

[Anonymous]

Hi all,

In my document I use this default settings:

SET ThousandSep: '.';

SET DecimalSep: ',';

I need this settings for the data I load into this document.

Right now I need to add a table file (html) which have numbers in it with a different ThousandSep (',') and a different DecimalSep ('.'). Is there a way to transform this settings when loading the data in a table?

Kind regards,

Henco

[#2]

Try to change the number format of Fields of the table file (html)...

[maxgro · Accepted solution]

did you try with ?

Num#( Field, '#', '.', ',') as NewField

[Sokkorn]

Hi Henco,

Here is sample:

Load

     Num(PurgeChar(FieldName,'.,' )) As Field,

     ...

From...

Regards,

Sokkorn

[Anonymous]

Thanks, that helps me out.

Kind regards,

Henco