I have over 7000 forum threads in an excel file. The data has two columns-
- Subject-> which tells about the problem that a customer is facing.
- Body-> the answers/posts on that forum thread.
What I want to accomplish is sort these forum threads into different categories. And I can do it only by reading text from the subject and body. Does anyone have a recommendation for a tool that can do this.
Primarily, the tool should have Control operators (If, elseif, etc.) and Boolean Operators(AND, OR, NOT). I want to sort these using variables (which will be certain keywords and hyperlinks).
Any help would be appreciated.