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

Data Cleansing Functions

Data Cleansing Functions

The transformation language includes a group of functions to eliminate data errors. You can complete the following tasks with data cleansing functions:
  • Test input values.
  • Convert the datatype of an input value.
  • Trim string values.
  • Replace characters in a string.
  • Encode strings.
  • Match patterns in regular expressions.
The transformation language includes the following data cleansing functions:
  • GREATEST
  • IN
  • INSTR
  • IS_DATE
  • IS_NUMBER
  • IS_SPACES
  • ISNULL
  • LEAST
  • LTRIM
  • METAPHONE
  • REG_EXTRACT
  • REG_MATCH
  • REG_REPLACE
  • REPLACECHR
  • REPLACESTR
  • RTRIM
  • SQL_LIKE
  • SOUNDEX
  • SUBSTR
  • TO_BIGINT
  • TO_CHAR
  • TO_DATE
  • TO_DECIMAL
  • TO_FLOAT
  • TO_INTEGER