WildCard Search in Tables
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 go...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
the syntax AND and OR in upper case have meaning as filter operators.
pras AND eggs
will 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 operator
The search is not case sensitive.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
the syntax AND and OR in upper case have meaning as filter operators.
pras AND eggs
will 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 operator
The search is not case sensitive.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- Mark ,
my big fat thanks !!
------------------------------
Prashant Maheshwari
------------------------------- MarkShnier__Youya pretty handy and certainly most regular users would not think to try that.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
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
There isn not native support for wildcards like that.
One option to note is that you can enter a search terms like
adam OR adjm with the OR in upper case.
