How to check if excel has expected mail id using regular expression

1.I have excel i have read the email from excel and check
a. if email id columan has blank, emtec, cushwake, ashling .com then dont add that
row to
b.if my mail is like abc@gmail.com,abc@yahoo.com then only i can add to queue but i have to check format of mail using regular expression

can anybody help me on this

HI @Sandhya_Gajare

You can use the Is Match Activity and use the pr defined expression in the wizard

Regards
Sudharsan

Checkout this thread too @Sandhya_Gajare

Hi @Sandhya_Gajare ,
Please use the following regular expression to validate email id: /[A-Za-z0-9._%±]+@[A-Za-z0-9.-]+.[A-Za-z]{2,}/

image

Thanks & Regards,
Shubham Dutta

please help me out …its too urgent is there anyboday

You have two different answers @Sandhya_Gajare
Can you try those please?

Regards
Sudharsan

Please find attached

Main.xaml (11.0 KB)