Version

    Propercase

    Propercase step capitalizes first letters of each word in string columns. Note that it does convert any of the following letters to lowercase. If you want to make sure that there are no capital letters within words, use the Lowercase step first to convert all letters to lowercase.

    Parameters

    • Input column: required, a string column containing input text.

    • Target column: required, configure the column which will receive the output. The output will always be of string type.

      • Write result to the current column: overwrite the Input column with the result.

      • Create new column with name: create a new column with specified name. Name of the new column can contain spaces or special characters - technical column name will be created automatically. The new column will be placed right after the Input column.

    Examples
    Input value Output value Explanation

    "product code name"

    "Product Code Name"

    First letters of all words are capitalized.

    "PRODUCT CODE NAME"

    "PRODUCT CODE NAME"

    No change; words in uppercase will remain in uppercase.

    "ProDuct cOde name"

    "ProDuct COde Name"

    First letters of all words are capitalized, and the uppercase letters in the middle of the words are retained.
    See also