Evaluates a String input against the Decimal datatype. If the input matches, the function outputs a Decimal value. Input can be a literal, a column of values, or a function returning String values.

After you have converted your strings values to decimals, if a sufficient percentage of input strings from a column are successfully converted to the other date type, the column may be retyped. 


parsefloat(strInput)

Output: Returns the Integer data type value for strInput String values.

parsefloat(str_input)


ArgumentRequired?Data TypeDescription
str_inputYStringLiteral, name of a column, or a function returning String values to match

str_input

Literal, column name, or function returning String values that are to be evaluated for conversion to Decimal (Float) values.


Required?Data TypeExample Value
YesString'5'


Example - type parsing functions