CLong Function
Returns the numeric form of a String as an Int64.
Syntax
result = CLong( string )
result = stringVariable.CLong( )
Parameters | ||
string |
Any valid String expression. |
Return Value | ||
Result |
The numeric equivalent of the string passed. |
Notes
The CLong function stops reading the String at the first character it doesn't recognize as part of a number. All other characters are automatically stripped.
It does recognize prefixes &o (octal), &b (binary), and &h (hexadecimal). However, spaces are not allowed in front of the ampersand. That is, " &hFF" returns 0, but "&h FF" returns 255.
CLong returns zero if string contains no numbers.
Examples
These examples use the CLong function to return the numbers contained in a String. literal or a String variable
Dim s As String
n = CLong ("12345") //returns 12345
n = CLong(" 12345") //returns 0
n = CLong("123 45") //returns 123
n = CLong(" &hFFF") //returns 4095
n = CLong(" &b1111") //returns 15
s="12345"
n=s.CLong //returns 12345
See Also
CDbl, CStr, Str, Val functions; &b, &h, &o literals; Int64 data type.