Validation before add into queue

[Aarti_Godhasara]

I want to add the data into the queue from the excel but before it inserts i want to verify that is it correct email or not it.

[Pradeep_Shiv]

correct email or not?
you mean the email is in format or not? or you have to cross check the email ??

[Aarti_Godhasara]

format of the mail

[Pradeep_Shiv]

then you can use Matches activity to cross check if it’s the valid email id or not!
use this Pattern to check ([a-zA-Z0-9._%-]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,6})
in matches activity you can pass row(“yourMailColumn”).ToString

[Palaniyappan (Palaniyappan P)]

Hi
You can use IF activity and mention like this -

input should be your string stored in a variable named strinput - testemail@xxx.yyy ,

Now in if condition

System.Text.RegularExpressions.Regex.Ismatch(strinput.ToString,“^([\w.-]+)@([\w-]+)((.(\w){2,3})+)$”)

It its a match then gives true and goes to then part with string has a valid email address

Cheers @Aarti_Godhasara