PROPER function
This topic describes the formula syntax and usage of the PROPER function in the Data Quality Execute Formula transform.
Description
Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter, such as a space. Converts all other letters to lowercase.
The following expression capitalizes the first letter of each name in a concatenated full name.
PROPER([FirstName]&" "&[MiddleName]&" "&[LastName])Syntax
PROPER(text)