> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.