This article has expired. Please visit the OneCloud Knowledge Base for the latest documentation.
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:
Matches beginning of line
abc, abcdef.., abc123
Matches end of 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 any characters 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, aaac,
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.
Updated about a month ago