Search for multiple keywords in a string

Hi everyone,

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?

Hello @tara017,
You should do it like this:

  1. Get excel file range and assign it to DataTable
  2. Use for each row to go through each row
  3. Inside for each row loop do the substring or regex to search for particular words in current row

Can you please help me with point 3?

@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:

1 Like

Okay, thank you so much.

1 Like