![]() You probably noticed I embedded a lot of words directly in the function. If IsEmpty(stopWords) Then stopWords = Split("a about above after again against all am an and any are aren't as at be because been before being below between both but by can't cannot chat could couldn't did didn't do does doesn't doing don't down during each few for from further had hadn't has hasn't have haven't having he he'd he'll he's her here here's hers herself hi him himself his how how's i i'd i'll i'm i've if in into is isn't it it's its itself let's me more most mustn't my myself need needs no nor not of off on once only or other ought our ours out over own same shan't she she'd she'll she's should shouldn't so some such than that that's the their theirs them themselves then there there's these they they'd they'll they're they've this those through to too under until up very was wasn't we we'd we'll we're we've were weren't what what's when when's where where's which while who who's whom why why's with won't would wouldn't you you'd you'll you're you've your yours yourself yourselves ? ! " & _ĭim stopR As Range, r As Variant, col As Collection that will dilute the fuzzy algorithm.įunction RemoveStopWords(sentence As String) As Collection This will help us get rid of all those unnecessary words like “the, it, this” etc. ![]() MsgBox "KnowledgeBase worksheet not found!~", vbCritical + vbOKOnly, "Error"īefore we focus on generating matches let us focus for a sec on creating a function that will remove stop words from a given sentence. If ws.Name Like "KnowledgeBase*" And ws.Visible Then Set dict = CreateObject("Scripting.Dictionary")įor Each question In wsQnA.Range("C:C").SpecialCells(xlCellTypeConstants) TbSelectedQuestion.Text = Selection.Value This makes it easier to copy the results where neededįirstly we will initialize our UserForm and assure it is showing us the current list of categories in our “KnowledgeBase” worksheet:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |