Change text casing

The Change text casing step converts the text in any column to a selected case type.

Input/output

Our input data is customer information that displays first name, last name and company in all normal case "Title Case". We can use the Change text casing step to turn our "First Name", "Last Name" and "Company" columns into upper case.

As seen in our output data below, this step made our "First Name", "Last Name" and "Company" columns change into upper case.

Settings

The first thing to do when you connect data to the Change text casing step is to Pick the dataset and the column(s) you'd like to Recase. You can select as many columns as you need.

Then, you will select the desired Case Type. The available case types are:

• Lower Case (this is lower case)

• Upper Case (THIS IS UPPER CASE)

• Title Case (This is Title Case)

• Sentence Case (This is sentence case)

• Swap Case (ThIs Is SwAp CaSe)

Helpful tips

• This step can only change one case type at a time. If you'd like to change the casing of your columns to different case types, you can do this by connecting a chain of multiple Change text casing steps one after the other.