Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

INITCAP - Capitalize each word in a string in Informatica

  1. Forget Code
  2. Informatica
  3. INITCAP - Capitalize each word in a string
Capitalizes first letter of each word in string and converts rest of the character to lower case. When a non-alphabetic character is found in the first position, informatica capitalizes the next character till a alphabet is found.
Syntax 
INITCAP( string )

ArgumentRequired/OptionalDescription
stringRequiredAny datatype except Binary. You can enter any valid transformation
expression.

Example : Capitalize first letter of a word
InputOutput
NULLNULL
tomTom
35jerry35Jerry
KINGKing
10qUEEEN10Queen
chess boardChess Board