Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Dates
  6. Functions
  7. Creating Custom Functions
  8. Custom Function API Reference
  9. POWERCENTERHELP

Transformation Language Reference

Transformation Language Reference

INITCAP

INITCAP

Capitalizes the first letter in each word of a string and converts all other letters to lowercase. Words are delimited by white space (a blank space, formfeed, newline, carriage return, tab, or vertical tab) and characters that are not alphanumeric. For example, if you pass the string ‘…THOMAS’, the function returns Thomas.

Syntax

INITCAP(
string
)
The following table describes the argument for this command:
Argument
Required/
Optional
Description
string
Required
Any datatype except Binary. You can enter any valid transformation expression.

Return Value

String. If the data contains multibyte characters, the return value depends on the code page and data movement mode of the
PowerCenter Integration Service
.
NULL if a value passed to the function is NULL.

Example

The following expression capitalizes all names in the FIRST_NAME port:
INITCAP( FIRST_NAME )
FIRST_NAME
RETURN VALUE
ramona
Ramona
18-albert
18-Albert
NULL
NULL
?!SAM
?!Sam
THOMAS
Thomas
PierRe
Pierre