Hello. I am trying to read every cell in an excel sheet, identify if it is an email address using RegEx in ‘Is Match’, and if it is an email, write it onto another sheet.
I am using two for loops to read cell by cell and if it is an email, adding a row in a data table ‘email’, which I use to write to the new sheet.
However, the bot is not giving an output. I have attached the xaml file.
P.S : I am aware of the method which concatenates strings and searches using ‘matches’ method. However I am curious to see if can do by using ‘Is match’ too.Main.xaml (15.6 KB)