Converts a string with numbers to a value.
Syntax
VALUE(String)
Input
String | is a string consisting of numbers, optionally preceded with a minus sign and optionally containing a dot. |
Domain type: | system domain String |
Output
VALUE returns: | a real value |
Domain type: | system domain Value |
Notes:
Tip:
When the definition symbol = is used, a dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output column has been calculated.
Usable in
Examples
Pocket line calculator examples:
? VALUE("45") |
returns 45.000 |
? VALUE(-38.5) | returns -38.500 |
TabCalc example:
OutCol1 = VALUE(InCol1)
OutCol2 = VALUE(SUB(InCol2,2,2))
InCol1 |
InCol2 |
OutCol1 |
OutCol2 |
0 |
A11 |
0.000 |
11 |
0.1 |
A12 |
0.100 |
12 |
-1.5 |
A20 |
-1.500 |
20 |
25 |
A30 |
25.000 |
30 |
999 |
B10 |
999 |
10 |
A300 |
B21 |
? |
21 |
ABC |
B22 |
? |
22 |
? |
? |
? |
? |
Column ColOut2 contains the values of a sub string of column InCol2. The sub string starts at position 2 and takes 2 characters into account; when the result of the sub string is a number, then this is converted to a value.
See also: