OneCloud

Common Regular Expressions for CSV

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:

Character
What does it do?
Example
Matches

^

Matches beginning of line

^abc

abc, abcdef.., abc123

$

Matches end of 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 any characters 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, aaac,

?

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

Updated about a month ago

Common Regular Expressions for CSV


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.