ETL: ParseLongOrDefault

Safely convert a string to a long integer, returning a default value if conversion fails. Use for resilient large number parsing in ETL pipelines.

Description

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

Syntax

ParseLongOrDefault(string_expression, default_value)

Arguments

string_expression - string

default_value - long

Examples

ParseLongOrDefault(string1,42L) Using string1 as input

ParseLongOrDefault('14607340342631',42L) Will output: “14607340342631”

ParseLongOrDefault('Universe',42L) Will output: “42”

Return value datatype

Long

Impact of null value

If input is null, returns null.