Convert a Text String Into a Number

To convert a text string into a number, you can use the Number function. For example:

the product’s calculated interest rate = Number(the product's interest rate) * 100

The text string in this function can be either a value or a non-Boolean attribute. If it is a value it must be in quotation marks (for example, "123").

In combination with the Substring function, you could use the Number function to extract the number part of a text string to a number attribute. For example:

the number at the end of the course code = Number(Substring(the course code, 4, 4))

If the course code was LAWS2001, this rule would infer the number at the end of the course code to be 2001.

Note that non-finite values such as "Infinity" and "NaN" ('not a number') will return uncertain.