What is the formula to enter in the “IF condition” to only select row containing a specific word.
For more explanations:
I have extracted the data of a website (Tokyo weather forecast) using the data scraping activity.
Now I only want to keep the data of the sunny days. (So on my IF conditions, only extract row containing the word “Sunny”).
I saw the file it has two columns where the first one is for the days (today, tomorrow etc) and the second column is the description of the weather (Used google translator to understand the data :D)
So you can filter the data table with the keyword sunny (晴れ) (I hope this is the correct word in Japanese, if not you can use the exact word in the query below ?)
Note that your excel columns do not have any header so UIPath read range activity will take Column0, Column1 as two headers. Make sure you uncheck the Add Header checbox of read range activity.