Hello,
I would like to know if Alteryx can find a sentence with a keyword in it from a .txt file and somehow return that sentence to me? I know this might be a long shot but it would be SO HELPFUL when analyzing regulatory documents.
The key words I would like to use are: shall, may, may not, should, should not, must, can, cannot
Thank you in advance!
Solved! Go to Solution.
hi @krobot0915
Was thinking that if the sentences have periods (.), use that as a delimiter to split by rows with the text-to-column tool, so that each sentence would be have its own row. Then with the filter tool, use the contains expression to find the keywords. If you post the dataset, I'd be happy to take a look.
Hi @krobot0915
Thanks for providing that. There's many ways to address this in Alteryx. My approach is similar to my initial reply. See attached. Hope that helps!
Hi @CarlDi,
I really appreciate your help. However, I have been unable to open your file, is there a special way I should be opening it? It seems like your alteryx version is newer than mine and I am trying to download the newest version in order to open your file but it doesnt seem to be working. Would you mind walking me through the steps you took or providing the workflow?
Thank you very much!
CarlDi,
Thank you very much for your help! This works perfectly!
Hi,
I was going through the post. Looks interesting. Can you please let me know how to convert the .pdf to txt in Alteryx?
Thanks
Sriniv