MoneyWorks Manual
TextToNum (text [, specialFormat])
Result Type: Number
Definition: Converts the given text to a numeric value. Use this when you need to perform arithmetic on the value.
Examples: TextToNum("42") + 2 — returns 44.
Compare this with "42" + 2, which gives a result of “422”.
In MoneyWorks 9.1.4 and later, you can supply an optional specialFormat parameter to have this function parse the text as a hexadecimal value. Values for this parameter may be one of NumFormHex16,NumFormHex32,NumFormHex16LE,NumFormHex32LE.
In MoneyWorks 9.1.8 and later, you can specify the optional specialFormat parameter as NumFormPrintf to have the text parsed as a non-localised number (i.e. always . decimal). Use this for parsing output from the Analyse function, which is always non-localised.