Boolean search in ODS is a search with the ability to set logical conditions for the presence or absence of certain keywords or phrases in the text of a ODS file.

In this online Boolean search in ODS app, conditions are specified using the special words AND, OR, NOT – always in upper case. In this case, the word AND forms a query for which all ODS files will be found, where there are words from the left and right parts of the AND expression at the same time. The word OR forms a query for which all ODS files will be found, where there are words from the left or right sides of the OR expression, or from both at the same time. The combination of words AND NOT forms a query for which all ODS files will be found where the words from the left side of the expression are present, but the words from the right side of the expression are absent.

A boolean search example using the word AND: "Einstein AND Albert". This query will return all ODS files whose text content contains both the words "Einstein" and "Albert".

A boolean search example using the word OR: "relativity OR quantum". This query will return all ODS files whose text content contains at least one of the two words – "relativity", "quantum".

A boolean search example using the words AND NOT: "quantum AND NOT Einstein". This query will return all ODS files whose text content contains the word "quantum" but does not contain the word "Einstein".

The full-text search engine GroupDocs.Search, on which this application is based, supports arbitrary depth of nesting of boolean search operators. Parentheses can be used to specify the order in which a boolean expression is evaluated.

How to search with boolean operators in ODS

  • Click inside the file drop area to upload a ODS file or drag & drop a ODS file.
  • Once upload completes, you will be able to perform search in your ODS file.
  • Enter your search query consisting of search words, boolean operators, and parentheses, if necessary.
  • Get results by clicking the "Search" button.
  • Add more ODS files with "Add files" button.
  • Select added files to include them into the index and perform searches.

Frequently asked questions

  • How does the online app Boolean Search in ODS work?

    The search is performed in two stages. First, documents are added to an index. And only then the search is performed in the index.
  • What about privacy, is it safe to use the online app Boolean Search in ODS?

    Access to your folder with uploaded and indexed files is only available to someone who has a link. All uploaded files are deleted from the servers after 24 hours.
  • Is an internet connection required to use the online app Boolean Search in ODS?

    This application is client-server. If you lose your internet connection while using the app, you won't be able to get search results.
  • Can I search on Linux, Mac OS, Android?

    You can search from any device, regardless of the operating system, that has a modern browser and an internet connection.

Other file formats supported by Boolean search app

You can also perform boolean search in many other file formats. Please see the full list below.

Viewer Annotation Conversion Comparison Signature Assembly Metadata Search Parser Watermark Editor Merger Redaction Classification Splitter Translation Unlock Protect Scanner