CAS 6

makenum
- Miscellaneous

Summary

Convert a field from text to numeric, ignoring various symbols such as $ and %. If field is already numeric, leave it alone. If field contains erroneous data, make it 0. The makenum function will always default to US currency. For European currency set the optional left argument to 1

Examples

makenum LOANID
makenum '20'
makenum '7.59%'
makenum '$7,509,622.13'
1 makenum '7.509.622,13'
makenum 'ABC2'
makenum 2

Syntax

(EuropeanFlag) makenum TextField

Left Arguments

Name	Data Type	Input Type	Description	Optional	Default
EuropeanFlag	Boolean	Field, Constant	European Format Flag 1=European, 0=US	Yes	0

Right Arguments

Name	Data Type	Input Type	Description	Optional	Default
TextField	Text	Field, Constant	Input Field	No

Result

Type: Numeric