Finding/Searching for Data
Performing Standard Data Operations > Finding/Searching for Data
Finding and Searching for data in a table is a cornerstone of all data analysis. Strata provides two ways to find data -- a "Quick" Find and a more customizable Find panel.
Using Quick Find
The Quick Find can be found on the toolbar at the top right of your screen and shares the same "Find/Filter" criteria box as the Quick Filter utility.
The above picture shows an standard data set. However, if we wanted to quickly find a cell that contained "ABC", we could simply enter "ABC" into the Find box and click on the "Find Next" icon as shown below:
One of the nice features of the quick find is that it will accept broad criteria than is necessary when performing most data operations, which require precise formulas. For example, we could use the find criteria "ABC" or "abc" or AbC" and still get the same result (for matching by case or whole word, see the section "Using the Find Panel" below).
By default, the quick find will find any data in your data set. However, if you want to be more specific, you may just highlight the field(s) you where you want to find your data and the quick find will limit the criteria to those selected fields.
The quick find also offers a mechanism for entering in custom Boolean formulas, similar to what you can do with other data operations:
In this example, we've created a formula so that, when we click "Find Next," we see only the records that match this formula.
Lastly, you may use the Find Next icon to move forward in your search results or you may just tap the Enter key. Hold down the Shift key and press Enter key to Find Previous results.
NOTE: When matching using a Boolean formula, Find Next will take you to the next record which matches the find criteria, not the specific cell as with standard matching.
Using the Find Panel
Sometime it is useful to have additional tools to help find items, including the ability to match upon the case of the word and matching on the entire word as well as finding in different contexts. To use the find panel, select "Find" from the Edit menu.
The Find panel works similarly to the Quick Find as discussed above. However it also provides three modes and two further options to narrow your search:
NOTE: The criteria selected in the Find Panel will determine how the Quick Find/Filter box behaves. For instance, if the Match Case is checked in the Find Panel and then the Quick Find box is used later, all Quick Finds and Quick Filters will be limited to the Case used in your criteria.
Formatting Considerations for Number and Date Searches
The above discussion has focused on text (character) searches. Below is further considerations to keep in mind for Number and Date searching: