Preface
Using the Designer
Working with Sources
Working with Flat Files
Working with Targets
Mappings
Mapplets
Mapping Parameters and Variables
Working with User-Defined Functions
Using the Debugger
Viewing Data Lineage
Comparing Objects
Managing Business Components
- Managing Business Components Overview
  - Business Component Locking
  - Creating Links to Business Component Documentation
- Managing Business Components and Directories
Creating Cubes and Dimensions
Using the Mapping Wizards
Appendix A: Datatype Reference
Appendix B: Configure the Web Browser
- Configure the Web Browser

Designer Guide

10.5
- 10.4.1
- 10.4.0

Back Next

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.

Working with User-Defined Functions Overview

Rename Saved Search

Table of Contents

Designer Guide

Designer Guide

Example

Example