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:
What does it do?
Matches beginning of a line.
abc, abcdef..., abc123
Matches end of a line.
my:abc, 123abc, theabc
Match any character
abc, asg, a123c
abc or xyz
Capture anything matched
Captures 'a' and 'c'
Matches anything contained in brackets
a, b, or c
Matches anything between 'a' and 'z'
bc, mind, xyz
The exact 'x' amount of times to match
Match 'x' amount of times or more
Greedy match that matches everything in place of the *
abc, abbcc, abcdc
Matches character before '+' one or more times
ac, aac, aac
Matches the character before the '?' zero or one times. Also used as a non-greedy match.
Escape the character after the backslash or create an escape sequence.
📚 Additional topics covered in this article: