ETL: ParseFloatOrDefault

Safely convert a string to a floating-point number, returning a default value on failure. Use for error-tolerant numeric parsing in ETL pipelines.

Description

Attempts to convert a string representation of a number to a floating-point numeric equivalent. If successful, returns the string as a floating point numeric value, otherwise returns the default value.

Syntax

ParseFloatOrDefault(string_expression, default_value)

Arguments

string_expression - string

default_value - float

Examples

ParseFloatOrDefault(string1,1.1f) Using string1 as input

ParseFloatOrDefault('0.551',1.1f) Will output: “0.551”

ParseFloatOrDefault('Testing',1.1f) Will output “1.1”

Return value datatype

Float

Impact of null value

If input is null, returns null.