Rex regular expression pattern matcher
The regular expression matcher allows you to find those items that cannot
be located with a simple wild card search. To invoke the REX regular
expression pattern matcher within a query precede the expression with a
'/' (forward slash).
Examples:
Expression Purpose
---------------------------------------------------------------------------
/g5 Finds all bracket types containing
"g5" in the Part Number; e.g.,
"G54", "g5220".
/\RPR[Oo]C\space \R means to "Respect Case".
Finds occurrences of the string
"PROC" or "PRoC" followed by a space
character, to find abbreviations for
"People's Republic of China".
/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+Clinton Find 'Clinton' as the first word
in a Paragraph
/\upper=\lower+\space\upper=\lower+ Proper Names without initials
like: John Smith
/(abc904) finds '(abc904)' anywhere it exists
|