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