I am new here and I have tried looking for a similar issue but cannot find help.
I want my sequence to first check if the cell says “google” and then go to google site. If it sees Bing then it should go to Bing. I am unable to do the string match correctly. Can you please help. Search Engine.xlsx (13.3 KB)
Use a read range to read excel sheet, assign to DT
Loop over DT
Use open url with value CurrentRow(1).ToString() since you have respective site for each search engine; you don’t need to use if else here:
In any case you want to perform different tasks related to site:
then you can use If inside loop => If CurrentRow(0).ToString.tolower.equals(“google”):
then tasks related to google
else:
tasks related to Bing
Thanks, my main challenge is first to check the string because if it says Google then go to the google site and if it sats Bing then go to their site. So, its the checking text which i am not able to do correctly
Hi @omer.tariq, Same think happen there, [In your Excel sheet] If first column’s first row is google means it goes to google, If first column’s second row is bing means it goes to bing.