Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.5.1
  3. Part 2: Versions 10.5 - 10.5.0.1
  4. Part 3: Versions 10.4.1 - 10.4.1.3
  5. Part 4: Versions 10.4 - 10.4.0.2
  6. Part 5: Versions 10.2.2 - 10.2.2 HotFix 1
  7. Part 6: Version 10.2.1
  8. Part 7: Version 10.2 - 10.2 HotFix 2

Text Functions

Text Functions

Effective in version 10.2.2, you can apply the following text functions to columns when you prepare data:
  • ENDSWITH
  • ENDSWITH_IGNORE_CASE
  • FIND_IGNORE_CASE
  • FIND_REGEX
  • FIRST_CHARACTER_TO_NUMBER
  • NUMBER_TO_CHARACTER
  • PROPER_CASE
  • REMOVE_NON_ALPHANUMERIC_CHARACTERS
  • STARTSWITH
  • STARTSWITH_IGNORE_CASE
  • SUBSTITUTE_REGEX
  • TRIM_ALL
  • Convert Date to Text
  • Convert Number to Text
  • Convert Text to Date
  • Convert Text to Number
For more information, see the "Prepare Data" chapter in the
Informatica 10.2.2 Enterprise Data Lake User Guide
.