parseDecimal
parseDecimal parses a string to determine if it contains a decimal
value. This function returns all rows that contain a decimal, integer, or null
value, and skips any rows that don't. If the row contains an integer value, it
is returned as a decimal with up to 4 decimal places. For example, a value of '2' is
returned as '2.0'.
Syntax
parseDecimal(expression)
Arguments
- expression
-
The expression must be a string. It can be the name of a field that uses the string data type, a literal value like
'9.62', or a call to another function that outputs a string.
Return type
Decimal(Fixed) in the legacy data preparation experience.
Decimal(Float) in the new data preparation experience.
Example
The following example evaluates fee to determine if it contains
decimal values.
parseDecimal(fee)
The following are the given field values.
fee -------- 2 2a 12.13 3b 3.9 (null) 198.353398
For these field values, the following rows are returned.
2.0 12.13 3.9 (null) 198.3533