| Table of Contents |
|---|
...
To concatenate several And/or conditions, add parentheses for each condition, as in the following example: IF(('unit_is_stationary' = 'Yes')&&('unit_is_stationary' = 'Yes'); 'OK';'Not OK')
Single quotes are supported inside a value only by prefixing them with the escape string(\) i.e. a formula
can look like this: 'unit_name' + ' Te\'st' and the result will be unit name Test
...
A regular expression (Regex) is a sequence of characters that specifies a search pattern of textual information. Usually, such patterns are used in order to filter text data before its presentation. Regular expression allows a combination of several filters together for example “and”, “or” filters.
Galooli’s Pro solution allow you to perform a variety of simple filtering manipulations on the textual data such as “Text Contain”, “Text Not Contain” before you run the report.
...
These filtering tools facilitate the analysis of the final information obtained from the report and save time so the user does not have to use formulas or tools in third-party solutions such as Excel.
However, sometimes more advanced filtering manipulations are required, and here the Regular expression filtering tool can be very useful.Full information about regular expression usage can be found here
The use of the tool
A regular expression (Regex) is a sequence of characters that specifies a search pattern of textual information. Usually, such patterns are used in order to filter text data before its presentation. Regular expression allows a combination of several filters together for example “and”, “or” filters.
Find a textual report and choose the Regular expression option
Write the appropriate formula for the required filtering
...
Limitation
A regular expression can be used in textual fields only.
Examples of common formulas
Expressions | Formula |
|---|---|
XX OR XX | (XX|XX) |
XX AND XX | (?=.*XX)(?=.*XX) |
Not XX OR Not XX | ^(?!.*(XX|XX)).* |
XX=the expression
Example of using the tool
Example #1
For example, if your report contains two columns:
“Unit Name” field - Textual field that contains all the organization vehicle models (Mazda, Opel, Ford, Honda, etc.)
“Status” field - Field that presents a variety of statuses of the vehicle (Disconnected, Moving, etc.)
Now your mission is to find only the Mazda OR the Ford modules that their status is disconnected.
In this situation, you should use the Regular expression tool in the following way:
Choose the “Regular expression” in the “Unit Name”
Write the appropriate formula XX|XX. In this case, the XX is the name of the cars model
Choose the “Disconnected” status in the “Status” field
Run the report
You will get only the disconnected MAZDA or FORD models
...
Example #2
For example, if your report contains one column:
“Unit Name” field - Textual field that contains all the organization sites names (Site1, Site 2, Site3, Site4, etc.) AND the identification number of each site (ABC123, ABC456, ABC789, DEF123, DEF456, DEF789, etc.)
Now your mission is to find only Site1 AND that their identification number contains ABC letters. It is important to emphasize that using AND formula requires that all the information appears in the same field (Site1 ABC123 for example)
In this situation, you should use the Regular expression tool in the following way:
Choose the “Regular expression” in the “Unit Name”
Write the appropriate formula (?=.*XX)(?=.*XX). In this case, the XX is the name of the site, and the identification number
Run the report
...