Validation before add into queue

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.

1 Like

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

format of the mail

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

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.