CLong Function

Returns the numeric form of a String as an Int64.

Syntax

result = CLong( string )

result = stringVariable.CLong( )


Parameters

string

String

Any valid String expression.


Return Value

Result

Int64

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 n As Int64
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.