Number format

[#1]

Hi All, I was trying to convert a value which is in text format to number.

I have field '0000000000000000158,15' in text format. I need this field en number format.

I try num ('0000000000000000158,15') but it isnt work.

Thanks and best regards

Ivan.

[hic]

There are too many digits. Try this instead:

     Evaluate(Subfield(Number,',',1)) + Evaluate('0.' & Subfield(Number,',',2)) as Number

HIC

[#3]

Try this instead but it isnt work.

This worked when divided into two instead.

I made.

One:

LOAD

  num( replace(ltrim(replace(Evaluate(Subfield(@180:209,',',1)),'0',' ',)),' ',0)) as NumberI,

  num(Evaluate('0.' & Subfield(@180:209,',',2))) as Number,

FROM

(fix, codepage is 1252);

Two:

LOAD

NumberI + Number as SDO_ACDO

Resident One