Get our latest book on "Top 10 artificial intelligence myths."
Download

Last updated

March 3, 2021

Table of contents

How to search with operators and wildcards

Impira enables you to run advanced search queries via operators (and, or, etc.) and wildcards (*, ?, etc.)

Let’s imagine that you have a collection with a number of Return Merchandise Authorization forms.  On these forms, you have extracted some fields including Originator, Vendor, Part Number, Quantity, and Date.

Screen_Shot_2020-12-11_at_4.10.40_PM.png

Operators

To search for only those files for which Bella was the originator, enter:

Originator:Bella

To search for only those files where Bella is the originator and the Vendor is Tribeca, enter:

Originator:Bella Vendor:Tribeca

To search for only those files where Bella is the originator OR Vendor is Tribeca, enter:

Originator:Bella or Vendor:Tribeca

To search for files where Bella is the originator and Tribeca is NOT the vendor, include a minus symbol:

Originator:Bella -Vendor:Tribeca

For fields (column names) that contain a space, such as Part Number, enclose the text in backticks, for example:

`Part Number`:12345-A

Important: Be sure to use backticks and not single quote characters!

Similarly, if the value you’re searching for contains spaces you should enclose the value in backticks, for example:

`Part Number`:`12350 ABC`Originator: `Bella Donna`

Range

To set lower and upper bounds in a query, you can also use range operators, such as greater than (>), less than (

The syntax is as follows:

Greater than Date:>2020-10-05
Less than Date:<2020-10-31
Range Date:>2020-10-05 Date:<2020-10-25

The following query free-text searches for ‘motherboard’ in files where the Quantity field is less than 10 and the Date is greater than March 23rd, 2020.

motherboard Quantity:<10 date:="">2020-03-23</10>

Wildcards

You can also use wildcards in your searches to match fields where the term given in the query is part of a longer string.

Impira supports the following wildcards:

  • Asterisk (*): Matches any character sequence (including the empty one)
  • Question mark (?): Matches any single character

For example, the query below matches any filename that ends with .jpg:

File:*.jpg

The following query would return matching search results for files containing text such as Apple, Addle, or Ankle:

Vendor:A??le