Initcap (Aster Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

This operator is only available when connected to an Aster database.

The Initcap operator converts the first letter of each word to uppercase and the remaining letters to lowercase.

The Initcap operator considers a word to be a string of alphanumeric characters separated by a non-alphanumeric character.

When dragging an Initcap operator into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - String Functions > Initcap