The OneCloud commands Column Filter, Filter Rows, and Find and Replace all have a Pattern type option to use Regular Expressions (a.k.a. “Regex”). Regex is a powerful string of text that allows patterns to be matched and located. Here are some examples:
Character | What does it do? | Example | Matches |
^ | Matches beginning of a line. | ^abc | abc, abcdef..., abc123 |
$ | Matches end of a line. | abc$ | my:abc, 123abc, theabc |
. | Match any character | a.c | abc, asg, a123c |
| | OR operator | abc|xyz | abc or xyz |
(...) | Capture anything matched | (a)b(c) | Captures 'a' and 'c' |
[...] | Matches anything contained in brackets | [abc] | a, b, or c |
[a-z] | Matches anything between 'a' and 'z' | [b-z] | bc, mind, xyz |
{x} | The exact 'x' amount of times to match | (abc){2} | abcabc |
{x,} | Match 'x' amount of times or more | (abc){2,} | abcabc, abcabcabc |
* | Greedy match that matches everything in place of the * | ab*c | abc, abbcc, abcdc |
+ | Matches character before '+' one or more times | a+c | ac, aac, aac |
? | Matches the character before the '?' zero or one times. Also used as a non-greedy match. | ab?c | ac, abc |
\ | Escape the character after the backslash or create an escape sequence. | a\sc | a c |
📚 Additional topics covered in this article:
Find and Replace - Single Character
Find and Replace - Multiple Values
What are Regular Expressions (RegEx)?