Text Case Transform
Text Case standardizes capitalization in selected text columns. Consistent case makes values easier to read, compare, and use in case-sensitive operations.
Basic Usage
To change the case of text:
- Select Text Case from the transform menu.
- In Columns to Consider, select the columns to update.
- Choose a Text Case Option.
- Select Apply.
Configuration Options
Basic Options
- Columns to Consider: Select the columns to update. Only non-numeric columns are available.
- Text Case Option: Choose the new capitalization:
UPPERCASE: Changes all text to uppercase.lowercase: Changes all text to lowercase.Title Case: Capitalizes the first letter of every word.
Examples
These examples show how each selected column changes while unselected columns stay as they are.
Example 1: Converting to Uppercase
Input Dataset:
| Name | City | Age |
|---|---|---|
| john doe | New York | 30 |
| Jane Doe | Los Angeles | 25 |
| bob smith | Chicago | 35 |
Configuration:
- Columns to Consider:
Name,City - Text Case Option:
UPPERCASE
Result:
| Name | City | Age |
|---|---|---|
| JOHN DOE | NEW YORK | 30 |
| JANE DOE | LOS ANGELES | 25 |
| BOB SMITH | CHICAGO | 35 |
Example 2: Converting to Title Case
Input Dataset:
| Product | Category | Price |
|---|---|---|
| LAPTOP PRO | electronics | 999.99 |
| wireless mouse | ACCESSORIES | 29.99 |
| USB-C cable | accessories | 14.99 |
Configuration:
- Columns to Consider:
Product,Category - Text Case Option:
Title Case
Result:
| Product | Category | Price |
|---|---|---|
| Laptop Pro | Electronics | 999.99 |
| Wireless Mouse | Accessories | 29.99 |
| Usb-C Cable | Accessories | 14.99 |
tip
Check proper nouns and abbreviations after using Title Case or UPPERCASE; those terms may need different capitalization.
caution
Text Case affects only text. Numeric columns and other non-string data types are not changed.
Best Practices
- Clean inconsistent values before changing their case.
- Choose a case that suits how the data will be displayed or compared.
- If the original capitalization matters, copy those values to new columns before overwriting them.
- Review mixed-case values, special formatting, proper nouns, and abbreviations after the transform.