Skip to Content

Change Case

Change the case of text in a set of columns.

Examples

name
John Doe
Uppercase
name
JOHN DOE
name
John Doe
Lowercase
name
john doe
name
john doe
Capitalize
name
John doe
name
JOHN DOE
Uncapitalize
name
jOHN DOE

Configuration

Column

Select the columns you want to edit.

Update Method

Select one of the options below. See the examples above.

Update MethodBehavior
UppercaseSets all alphabetic characters to upper case.
LowercaseSets all alphabetic characters to lower case.
CapitalizeSets the first character in the cell to upper case, if alphabetic.
UncapitalizeSets the first character in the cell to lower case, if alphabetic.

Where

Add a condition to specify when the transform should be applied. If this condition is not met for a row, the value in the selected column will remain unedited.

Screenshot of configuring the Casing transform