To read every cell in excel, identify an email address and write to another sheet

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)

Could you also attach the xlsx file? :slight_smile:

Oops.
Here you go: Sample Data.xlsx (11.9 KB)

So I’ve tested your flow ( I had to recreate it because Is match activity is not compatible), and I got the results.

I used this regex : “\w+@\w+.\w+”

DataRowandDataColumn.xaml (11.8 KB)

Made some rookie mistakes. Works alright now.
Thanks! :smiley:

1 Like

Glad to hear that @Mrud2517