Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

TO_FLOAT

TO_FLOAT

Converts a string or numeric value to a double-precision floating point number (the Double datatype). TO_FLOAT ignores leading blanks.

Syntax

TO_FLOAT(
value
)
The following table describes the argument for this command:
Argument
Required/
Optional
Description
value
Required
Must be a string or numeric datatype. Passes the values you want to convert to double values. You can enter any valid transformation expression.

Return Value

Double value.
NULL if a value passed to this function is NULL.
0 if the value in the port is blank or a non-numeric character.

Example

This expression uses values from the port IN_TAX:
TO_FLOAT( IN_TAX )
IN_TAX
RETURN VALUE
'15.6789'
15.6789
'60.2'
60.2
'118.348'
118.348
NULL
NULL
'A12.3Grove'
0