Change text casing
The Change text casing step converts the text in any column to a selected case type.
Our input data is customer information that displays first and last names in all uppercase. We can use the Change text casing step to turn our first and last names into title case.
As seen in our output data below, this step made our "first_name" and "last_name" columns change into title case.
The first thing to do when you connect data to the Change text casing step is to select 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:
- Upper Case (THIS IS UPPER CASE)
- Lower Case (this is lower case)
- Title Case (This is Title Case)
- Sentence Case (This is sentence case)
- Proper Case (This Is Proper Case)
- 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. (This step can only change one case type at a time.)