[Version: 2024 - September]
[Build: 24.09.03003]
Converts a long integer string to a 64 bit integer.
(string longString)
Returns long value based on passed value.
Example: ToInt64("100") returns long value (100).
longString: Required. The value of the long.
(string longString, bool isSafeCast)
Returns long value based on passed value.
Example: ToInt64("INVALID", true) fails with conversion error and returns a default value (0).
longString: Required. The value of the long.
(string longString, bool isSafeCast, int defaultValue)
Returns long value based on passed value.
Example: ToInt64("INVALID", true, -1) fails with conversion error and returns a passed default value (-1).
longString: Required. The value of the long.
Examples
The two LongIntString values are formatted as strings in Excel ('12345678000000 and '87654321000000):
When one of the strings cannot be converted to an integer:
Using the 'isSafeCast = true' option to convert data despite incorrect format:
Comments
Please sign in to leave a comment.