Finding an exact match in an excel file
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I currently have a workflow which uses the contains() function to search through a column:
The issue I am having is I only want to find the exact words specified in my excel input, but contains() will return a positive result even if a word happens to be within a word in my input file e.g. if i want to search for "hug", the workflow returns a positive value whenever it finds the word "huge"; but I only want to see a positive result if the exact word is found.
Any ideas?
Solved! Go to Solution.
- Labels:
- Data Investigation
- Text Mining
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @srea541
Give my previous response in this post a try.
I am using find and replace which has the match word option. If it doesn't work let me know.
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much! Sorry I didnt see that yesterday lol
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @srea541
Cheers and have a nice day!
