Table of Contents

Search

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

Transformation Language Reference

Transformation Language Reference

Character Functions

Character Functions

The transformation language includes the following character functions:
  • ASCII
  • CHR
  • CHRCODE
  • CONCAT
  • INITCAP
  • INSTR
  • LENGTH
  • LOWER
  • LPAD
  • LTRIM
  • METAPHONE
  • REPLACECHR
  • REPLACESTR
  • RPAD
  • RTRIM
  • SOUNDEX
  • SUBSTR
  • UPPER
The character functions MAX, MIN, LOWER, UPPER, and INITCAP use the code page of the
PowerCenter Integration Service
to evaluate character data.