Returns the numeric value of a character string. This feature enables you to perform numeric calculations on the character strings.
Remark: This function is equivalent to
Val.
StringToNum("143") // Returns 143
StringToNum("1.67") // Returns 1.67
StringToNum("ABC") // Returns 0
StringToNum ("3plus2") // Returns 3
StringToNum("7,5") // Returns 7
StringToNum("1D2") // Returns 100
StringToNum("2.5e-2") // Returns 0.025
Syntax
<Result> = StringToNum(<Initial string> [, <Base used>])
<Result>: Real or integer
- Numeric value of the string.
- 0 if an error occurs.
<Initial string>: Character string or Buffer
Character string to convert to a numeric value.
For a real, the separator must be the dot ('.') and the prefixes for scientific notation can be 'E', 'e', 'D' or 'd'. If the separator is a comma, the numbers after the comma will be ignored.
<Base used>: Character string or integer (optional)
Base in which the number is represented. The possible values are as follows:- "d": base 10 (decimal)
- "x": base 16 (hexadecimal)
- "o": base 8 (octal)
- an integer between 2 and 36
Base 10 is used by default.
Remarks
Conversion range
StringToNum converts a string to an integer if the value is between -9.223.372.036.854.775.808 and 9.223.372.036.854.775.807.
Val function and UNICODE
The <Initial string> can be an ANSI or UNICODE string
Miscellaneous
If a character of <Initial string> cannot be interpreted as a number, StringToNum stops interpreting <Initial string> and returns the number corresponding to the characters already read.
Reals can be converted from base 10 only. In other bases, all characters after "." (point) will be ignored.