Want condition for incorrect email format

Help Studio
, ,
1

Hi
I have one excel sheet in that have candidate details, like first name, last name and email etc… I have given validation for all the details but I want validation for incorrect email format, if the email format is incorrect then the bot should throw exception.

Please suggest me some idea
Thanks.

2

You can use RegEx to determine if the email format is correct.

3

Hi Paul,
Can you give me any example on that, because i don’t have idea on Regex

Thanks

4

Hi @Keerthi_Dhanashrikar
Use this regex for email format
^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$

5

Hi Manisha,

Thanks for the help, Its working.

1 Like
6

@Keerthi_Dhanashrikar If the above answer helped, please mark it as solution.

Thanks!!

7

Hey @Keerthi_Dhanashrikar you can try it with using if condition
This image depicts a workflow check in which an 'Email' variable is tested to see if it contains "@" and outputs "Valid" if true or "InValid" if false. (Captioned by AI)

cheers Happy Automation