I have an excel sheet with a list of strings. I have to iterate through each row & search for keywords. For example- if the string is “whiskas kitten tuna cat food gravy”, then the result should be “cat food”. I have more than 100 different keywords to search for. How do I go about doing this?
@tara017 depends of how much complicated phrases you need to dig inside there are few methods.
Please check the topics on forum as Regex or Substring was described quite well many times. Let just give you some hints: