O'Reilly logo

Using OpenRefine by Max De Wilde, Ruben Verborgh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Overview

The following table provides an overview of the special symbols in regular expressions:

Symbol

Meaning

ABC… abc…

Match the corresponding letters literally

123…

Match the corresponding numbers literally

[xyz]

Match one of the characters inside the braces

[^xyz]

Match any character that is not inside the braces

[0-9]

Match one of the characters inside the range

\d

Match a digit

\D

Match a non-digit

\w

Match a letter, number, or underscore

\W

Match anything that is not a letter, number, or underscore

.

Match any character except a newline

\n

Match a newline

\.

Match an actual dot (the backslash escapes the next character)

?

Match the preceding item zero or one time

*

Match the preceding item zero or more times ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required