Table of Contents

Search

  1. Version 10.2.2
  2. Version 10.2.1
  3. Version 10.2
  4. Version 10.1.1
  5. 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 December 18, 2019