How do I create a multiple keywords search engine?

Question

Brian Kibe 2022-8-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1778185-how-do-i-create-a-multiple-keywords-search-engine

评论： Brian Kibe 2022-8-12

BMKS.xlsx

I am trying to create a multiple keyword search that will allow user to input upto 5 keywords on a display panel and use this data to search for the cell in excel that certisfy this. N/B Only cells with all the keywords certisfy. I would also like the final answer be an new excel file with only the data (raws) that certisfied user input. The user input should not be case sensitive(ignore case). Please help.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2022-8-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1778185-how-do-i-create-a-multiple-keywords-search-engine#answer_1025310

You can get the keywords from the user using any of inputdlg(), uitable(), uicontrol('style', 'edit') or uieditfield()

Once you have the list of keywords you can check cells using contains() or regexp. If you use contains you might want to use the new pattern() facility to "and" together several patterns.

Question: if the user asks for "cat" and the cell contains "scatter" should it match? What if it contains "cats"? If they ask for mouse and the cell contains "mice"? "ever" and the cell contains "when-ever"?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Brian Kibe 2022-8-12

Thank you for your response, but, I'm still unsure on how to use those functions. An example would help.

To answer you question, it shouldn't matter if, for an example, the user asked for 'cat' and matlab outputs cells that even contain 'scatter'. The user will be resposible to decide if they require the data or not after its provided. Also, even though the user is looking for 'mouse' and the cell contains 'mice', they will be resposible to try various ranges of keywords in order to attain reliable data.

请先登录，再进行评论。