Inconsistent text casing
What they are and how to fix them
What are inconsistent text casing?
Inconsistent casing appears when the same value is written as london, London, and LONDON. It fragments grouping, inflates unique counts, and hides duplicates. RxLint detects case inconsistencies so you can normalize columns quickly.
Example data with this issue
| city |
|---|
| London |
| london |
| LONDON |
Frequently asked questions
Why does casing inconsistency matter?
Case-sensitive systems treat differently-cased strings as separate values, which breaks aggregations and causes false duplicates.
Can RxLint normalize casing automatically?
Yes. Use quick fix to convert affected values to lowercase, uppercase, or capitalized format.