Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • xyz - searches for all data containing 'xyz'
  • between aaa and zzz - searches for alphanumeric values between 'aaa' and 'zzz'
  • between 10 and 20 - searches for numeric values between 10 and 20 
  • starts with xyz - searches for all data that starts with 'xyz'
  • values A, B, C, etc. - searches for a list of values (exact matches)
  • =xyz - searches for data equal exactly to 'xyz'
  • >123 - greater than search
  • >=123 - greater or equal to search
  • <123 - less than search
  • <=123 - less than or equal to search
  • !=xyz - searches for alphanumeric values that do not contain 'xyz'
  • !=123 - searches for numeric values that are not equal to 123


Info

As of version 6.9.0, blanks can now be filtered, and are represented by a single space. Valid expressions include: " ", "= ", "== ", and "values A, ,B"