Function EN Version 1.90

@TextToNumber

Float List Misc Text

Syntax

@TextToNumber(TEXT1);
@TextToNumber(TEXTLIST1);
@TextToNumber(TEXT1;MODE2);
@TextToNumber(TEXTLIST1;MODE2);

Description

Converts TEXT/TEXTLIST TEXT1/TEXTLIST1 into FLOAT/FLOATLIST and returns it. FN MODE2 can be used to specify the conversion mode; if it is omitted, zero is assumed.

NOTE:
@TextToNumber
in the Engine differs slightly from the Notes-@Function @TextToNumber!

MODE2 (Engine only):
0 = Decimal
1 = Hexadecimal

For ASCII values that cannot be converted, the Engine returns zero instead of @ERROR as Notes does.

Example: @TextToNber(TEXT1)

TEXT1:="18.1625";
@TextToNumber(TEXT1);

returns 18.1625

Example: @TextToNber(TEXTLIST1)

TEXTLIST1:="12.65":"14":"28.650";
@TextToNumber(TEXTLIST1);

returns 12.65:14:28.65

Example: @TextToNber(TEXT1;MODE2)

TEXT1:="1F2D345";
MODE2:=1;
@TextToNumber(TEXT1;MODE2);

Example: @TextToNber(TEXTLIST1;MODE2);

TEXTLIST1:="A546":"83CD4":"3B4E4";
MODE2:=1;
@TextToNumber(TEXTLIST1;MODE2);

returns 42310:539860:242916

Note : This text was machine-translated and may contain inaccuracies.