By default, Eofferix compares text without case sensitivity. For normal cleanup this is convenient: Black, black, and BLACK are treated as the same value in checks.
Enable Respect character case in a value when uppercase and lowercase letters must be different.
Where to Enable It
Open the settings of the result field, node, or column. In Additional settings, enable Respect character case in a value.
What It Affects
- Rule conditions: equals, not equals, contains, does not contain, starts with, ends with.
- Export conditions before and after transformations.
- Substring removal and replacement.
- Regular expressions: without the option, matching is case-insensitive; with the option, matching is case-sensitive.
- Actions "Remove after", "Remove before", and "Keep only matched part".
Examples
| Value | Condition | Option off | Option on |
|---|---|---|---|
ABC | equals abc | matches | does not match |
Product-ID | contains id | matches | does not match |
Color | replace color with Colour | replaces | does not replace |
What It Does Not Do
It does not change the text case by itself. To convert a value to lowercase, uppercase, or title case, use text transformation actions.