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 Data 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 |