WildCard Search in Tables

Question

Is it possible to do a wild search in regular table view?

Let's say I want to search for

pras* + eggs
or
egg + olive

Prashant is my name
Prashant eats eggs with butter
Prashant goes for rock climbing
Prashant makes eggs with olive oil

------------------------------
Prashant Maheshwari
------------------------------

markshnier__you · Answer

np,the syntax AND and OR in upper case have meaning as filter operators.pras AND eggswill give you hits where the search in any columns meet the criteria. The hits do not need to be on the same column.pres OR eggs will give more hits as it's an OR operatorThe search is not case sensitive.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

prashantmaheshw · Answer

Mark ,&nbsp;my big fat thanks !!------------------------------Prashant Maheshwari------------------------------

markshnier__you · Answer

ya pretty handy and certainly most regular users would not think to try that.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

savinewman1 · Answer

What if we want to search a term that could be spelled multiple ways?

Example:

Adam, or maybe Adam is spelled with a silent "J" so we search "Ad*m" because we're unsure how it's spelt but know it's different and it would pull anything that has "ADM" knowing the Asterix could be anything?

markshnier__you · Answer

There isn not native support for wildcards like that.One option to note is that you can enter a search terms likeadam OR adjm&nbsp; with the OR in upper case.

Forum Discussion

WildCard Search in Tables

Search and reports—wildcard searching

Related Content

How to configure global app search

Record limit when searching table

Moving Fields from One Table to Another

Table is missing

How to relate two tables with the key to a third table?