Category

String Functions

Description

Convert a string to a numeric value

Syntax

ToNum(string, nth)

Parameters

string - a literal string or string function result that can be parsed as an integer or decimal number

nth - the instance of a number to find within the string (optional)

Notes

If nth is not specified then this function only looks for a number at the beginning of the string.

If nth is 1 then the first number found within the string (or at the beginning) is returned.

If nth is 2 the second number found is returned, and so on.

A return value of 0 means either the number found was 0 or no number was found.

Copyright © 2020-2025 Systematic Solutions, LLC