ETL: ParseDoubleOrDefault

Safely convert a string to a double-precision number, returning a default value on parse failure. Use for resilient numeric parsing in ETL jobs.

Description

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

Syntax

ParseDoubleOrDefault(string_expression, default_value)

Arguments

string_expression - string

default_value - double

Examples

ParseDoubleOrDefault(string1,1.1) using string1 as input

ParseDoubleOrDefault('635.1',1.1) will output: “635.1”

ParseDoubleOrDefault(‘Testing’,1.1) will output: “1.1”

Return value datatype

Double

Impact of null value

If input is null, returns null.