Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.4.1
  3. Part 2: Version 10.4.0
  4. Part 3: Version 10.2.2
  5. Part 4: Version 10.2.1
  6. Part 5: Version 10.2
  7. Part 6: Version 10.1.1
  8. Part 7: Version 10.1

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
.


Updated August 28, 2020