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

String functions

String functions

The transformation language provides the following string functions:
  • ASCII
  • CHOOSE
  • CHR
  • CHRCODE
  • CONCAT
  • INDEXOF
  • INITCAP
  • INSTR
  • LENGTH
  • LOWER
  • LPAD
  • LTRIM
  • REPLACECHR
  • REPLACESTR
  • REVERSE
  • RPAD
  • RTRIM
  • SUBSTR
  • UPPER
To evaluate character data, the string functions LOWER, UPPER, and INITCAP use the code page of the Secure Agent that runs the task.

0 COMMENTS

We’d like to hear from you!