Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Text functions > GetAsNumber function |
|
|
| GetAsNumber function |
| Format |
GetAsNumber(text) |
| Parameter |
| text - any text expression or text field containing numbers |
| Data type returned |
| number |
| Description |
| Returns only the numbers in text, as data type number, for use with formulas involving numbers or numeric functions. The GetAsNumber function drops all non-numeric characters from text. |
| Examples |
| GetAsNumber("FY98") returns 98. |
| GetAsNumber("$1,254.50") returns 1254.5. |
| GetAsNumber("2 + 2") returns 22. |
| GetAsNumber(SerialNumber) returns 35684, when the value of SerialNumber is TKV35FRG6HH84. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Text functions > GetAsNumber function |
|
|
Next Page |
|