REX - Regular EXpression Pattern Matcher

Overview

The Regular EXpression pattern matcher allows you to find those items that cannot be located with a simple wildcard search.

To invoke the REX regular expression pattern matcher within a query precede the expression with a '/' (forward slash).

Examples

Expression Purpose
/19[789][0-9] Find years between 1970 and 1999
/[1-9][01][0-9]-?[0-9]{3}-=[0-9]{4} Any USA Phone Number
/\n=\space+Shakespeare Find 'Shakespeare' as the first word
/\upper=\lower+\space\upper=\lower+ Proper Names without initials
/(abc904) finds '(abc904)' anywhere it exists