Table of Contents

Search

  1. Preface
  2. Function reference
  3. Constants
  4. Operators
  5. Dates
  6. Functions
  7. System variables
  8. Datatype reference

Function Reference

Function Reference

Data cleansing functions

Data cleansing functions

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

0 COMMENTS

We’d like to hear from you!