Convert a text string into a number

To convert a text string into a number, you can use the following syntax with the Substring function:

 

For example, to extract the number part of the text string "LAWS2001" to a number variable, you would write the following rule:

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

This would infer the number at the end of the course code to be 2001.