Sunday, May 3, 2009

Filter Wild Cards

# Matches any numeric digit

@ Matches any alphabetic character

. (Period) Matches any non-alphanumeric character
                  ROOF.TR@@@ finds ROOF-TRUSS

* (Asterisk) Matches any text string and can be placed anywhere in the search string

? Matches any single alphanumeric character

~ (Tilde) Matches anything except
                 ~*DI* matches all strings that do not contain DI

[] Matches any one of the characters enclosed
    [XY]C matches both XC and YC

[~] Matches any character that is not enclosed
      [~XY]C matches AC but not XC or YC

[-] Matches a range for a single character
     [H-L]C matches HC, IC, JC, and so on but not MC

` (Reverse quote) Reads the next character
   `*XY matches *XY

No comments:

Post a Comment