This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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
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.
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?
Maybe this screenshot will help, I also attached the workflow in a yxmd file format. Be mindful of the Input data tool configuration - make sure the delimiter is \n and ensure field length is sufficient or it will truncate your sentences.