Number Parser

Function parsing strings to numbers

Evaluation

This expression evaluates to a function of the form:

(string x) -> any

The function is consistent with parser semantics used for string to data conversion, for example by the CSV Input step.

String x is converted into a number using the given pattern and locale.

If the ‘parse decimal’ setting is true, the result is a decimal value, otherwise the result is a long or double value.

If x is equal to the configured nil value, nil is returned.

If x is nil, nil is returned.

Name	Type	Description
Pattern	string	A Java DecimalFormat pattern.
Locale	string	The locale determines decimal point, grouping, and number characters
Trim	boolean	If `true`, whitespace from both ends of the string is trimmed before parsing. If `false`, the given string is parsed unaltered.
Parse Decimal	boolean	If `true`, the parser produces a value of type decimal. If `false`, the parses produces a value of type long or double.
Nil Value	datetime	If the string to parse is equal to this value, the function returns `nil`.