Enhanced Text Search functionality

[KeithMorris113]

The existing Text Search is really good and with the "" wildcard is does support ANDing of search terms.
e.g. a search term qualityfood would match strings "quality food" and "great quality and great food"

However it would be really powerful if additional search term operators could be added, such as the following examples

ORing - A logical OR of search terms so for example the terms pub OR bar OR club would match strings containing any of those terms removing the need to search for them separately

NOT - A logical NOT of a search term so for example pub NOT bar would find strings containing pub but not containing club

ANYORDER - Match ANDed terms that appear in any order in a string
e.g. ANYORDER [pub*bar] would match strings "I go to pubs and bars" and "I go to bars and pubs"

Many users are used to using advanced search operators and these types of additional operators would really add power to searching and analysing text data from sources such as social data, CX and user feedback.

[lordneeko]

In addition, if the box could search more than 1 field that would be phenomenal. Otherwise, I have to have multiple visuals to search multiple fields. I'd like to be able to search multiple fields (even if it is limited to only like 3 or 4 fields) for certain words within the data.