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)?

Smart Filter Rows Command


Did this answer your question?