Introduction
The Manual Coding screen in codeit contains features for searching and filtering data.
To use these features you can just enter a simple piece of text, e.g. Search for "service" or filter on "Female".
However, codeit also supports a more advanced Text Expression Syntax that you can use to perform more powerful searches and filters.
This page details the syntax and operations supported by codeit.
Boolean Search
The Text Expression Syntax provides a number of keywords you can use to form logical boolean (true/false) expressions. The following table lists the keywords available with an explanation and examples.
| Keyword | Description | Examples |
|---|---|---|
| AND | Joins search terms to form an expression where both terms must match to return a positive result | home AND comfort Returns all records containing “home” and “comfort” |
| Implicit AND | If more than one word is entered (without quotes or brackets) the expression is treated implicitly as an AND expression | home comfort Interpreted as home AND comfort and matches any values containing both search words anywhere in the text. e.g. "I like the comfort of home" |
| OR | Joins search terms to form an expression where either terms must match to return a positive result | home OR comfort Returns all records containing either "home" or "comfort" (or both) |
| NOT | Returns a positive result for values that do not contain the search term | home NOT comfort Returns all records containing "home" but not "comfort" |
| NEAR | Joins search terms to form an expression where both search terms must match within 5 characters of each other to return a positive result | home NEAR comfort Returns all records containing "home" and "comfort" within 5 characters of each other. |
| NEAR/n | Joins search terms to form an expression where both search terms must match within n characters of each other to return a positive result | home NEAR/8 comfort Returns all records containing "home" and "comfort" within 8 characters of each other. e.g. "I like the comfort of home" |
Keyword Case Sensitivity
All of the keywords above can be written as upper, lower or mixed case.
For example, the expressions: "home AND comfort", "home and comfort", "home And comfort" are all equivalent.
Quotes
Double quotation marks can be used to denote and exact phrase. For example, the expression "home comfort" will match on that exact phrase rather than performing and Implict AND (see above).
Brackets
Brackets can be used to form explicit sub-elements within an expression. For example, the expression (cost OR price) AND expensive will match all values that contain "expensive" and either "cost" or "price"
Keyword Precedence
When an expression contains multiple keywords, in the absence of brackets (see above) the keywords are interpreted in the following order: NOT > NEAR > AND > OR.