Forum Discussion
Ben_Nash
8 years agoFrequent Visitor
Return exact word from text string
Hi I am running a list of keywords against text and getting keywords returned in a column if they appear in the text. The below formula is working fine except I'm also getting words returned even...
v-piga-msft
8 years agoResident Rockstar
Hi Ben_Nash,
I have made a test with your formula, it seems that it works as expected.
More details you could have a reference of the attachment.
If you still need help, please share some data sample which could reproduce your scenario and your desired output, so that we can help further investigate on it?
Best regards,
Cherry
Ben_Nash
8 years agoFrequent Visitor
Hi Cherry
Thanks for your reply and testing.
An example of the problem I’m facing is with a keyword such as ‘taint’. I’m getting a return on the following text ‘If you like long lines, hidden fees, militaint staff, and all around terrible customer experiences’ whereas the formula should be ignoring this text and only returning on 'taint'
Thanks
Ben