Upper and Lower Case
Key points
- Choose IGNORE
- Enter the pattern
- Check it
In Regular Expression Builder you can ignore the difference between upper and lower case.
Steps
- Choose IGNORE
- Enter the pattern
- Check it
(?i) is added to the front of the pattern.
Use "Build a Regular Expression Formula" (free)
Tools that go well with this
- Regex Tester: Test regular expressions with matches and replacements.
- Build a SUBSTITUTE Formula: Build text replacement formulas.
- Build a SPLIT Formula: Build text splitting formulas.