English
  • PowerCenter 10.4.0
  • All Products

Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Designer Guide

Designer Guide

Back Next

Example

Example

You want to remove leading and trailing spaces from last names. You can create a user-defined function named RemoveSpaces to perform the LTRIM and RTRIM functions. When you configure the user-defined function, you enter the following expression:
LTRIM( RTRIM( name))
After you create the function, you can create the following expression in an Expression transformation to remove leading and trailing spaces from last names:
:UDF.REMOVESPACES(LAST_NAME)
The user-defined function name is prefaced by :UDF. The port name is LAST_NAME. It is the argument of the expression.