TextCase
Converts text to UPPER, lower, or Title Case. Its main job is cleaning up inconsistent capitalization, the kind that makes "ACME corp" and "acme CORP" look like two different customers when you group or match on the name.
Inputs
| Input | Accepts | Required |
|---|---|---|
Text | Text | Yes |
Case | Text | Optional |
Outputs
| Output | Produces |
|---|---|
Result | Text |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
Case | Upper | One of Upper, Lower, Title. Upper and Lower convert the whole text; Title capitalizes the first letter of each word ("acme holdings" becomes "Acme Holdings"). |
Example
Your Customers table came from three different exports, and Customer_Name
holds "ACME HOLDINGS", "acme holdings", and "Acme Holdings" as separate
spellings of the same account. Run the name through Text Case with Case set
to Title and all three become "Acme Holdings". A GroupBy on the cleaned name
then rolls their invoices up into one line instead of three.