Agent Ransack multiple term search in containing text

Question

I'm attempting to use Agent Ransack to search one search term with many other search terms, but need help formatting the containing text search criteria. For example, I'd be looking to search for bread AND (butter OR Jelly OR Peanut Butter OR Peanut OR mustard OR) etc...,

I tried the versions below resulting in no found items, trying to figure out the appropriate way to use AND,OR, quotations and parenthesis

Bread AND butter OR "Peanut Butter" OR jelly
(Bread AND) butter OR "Peanut Butter" OR jelly
(Bread AND) (butter OR "Peanut Butter" OR jelly)

How do I format the search to correctly provide a list of bread and other search terms? Would there be a result running this search with & without regular expression?

Comments

@shannon I'm not sure I understand your question by 'format the search', your expression looks just fine. Are you trying to load the terms from a file?

---

Thanks for getting back to me. I tried the versions below resulting in no found items, trying to figure out the appropriate way to use AND,OR, quotations and parenthesis

Bread AND butter OR "Peanut Butter" OR jelly

(Bread AND) butter OR "Peanut Butter" OR jelly

(Bread AND) (butter OR "Peanut Butter" OR jelly)

---

@shannon They should all work but this is how I'd phrase it:

Bread AND (butter OR "peanut butter" OR jelly)

If that doesn't work please send a sample text file to support@mythicsoft.com and I'll test it out.

---

Thanks, what's the difference between running this search with & without regular expression?

---

Thanks, would there be a result running this search with & without regular expression?

---

You need to make sure that "Regular Expression" is switched OFF in the Options tab.

---

Thanks, last question. A majority of the found items do not contain the "containing text" search terms as text. Instead the term appears in an imbedded script within a file, or image, but not the actual text within a document. Is there a way to filter out these results? Thanks

Answer 1

Make sure you switch OFF Regular Expression in the Options tab and try something like:

Bread AND (butter OR "peanut butter" OR jelly)

To search in ONLY document files specify which files you want to search in the File name field, e.g.

File name: *.txt;*.doc;*.docx

Comments

Thanks, but I still get inaccurate results. If I do a search for .doc files, some have the correct text. Some don't, but are highlighted because a search term is embedded somehow. When I click on "hits" a whole bunch of random characters are displayed including the search term. Ex. eG Cé bread ag+ However bread actually isn't in the document. There's probably a better way to explain but not sure. Thanks again for the help.

---

Please contact support@mythicsoft.com with a sample document that is not working. If you could include some screenshots showing your results that would be great.