Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Email Validation in talend

Problem statement:

 

An email address looks like this: blablabla@blabla.com

The part before "@" is termed as local part while the part after that is called as domain.

The requirement is to build a regular expression that matches this syntax. The specifications of the syntax are as follows:

 

1) The local part can be either of these characters

abcdefg.hijklmnopqrstuvwxyz!#$%&'*/=?^_+-`{|}~0123456789

 

2) The local part can contain two consecutive periods/dots (..) but only at the middle or at the end of the local part.

Valid cases - "blabla..blabla@blabla.com" and "bla..@blabla@com"

Invalid cases - "..blabla@blabla.com"

 

3) Comments - denoted by matched parentheses - are allowed in the domain part as well as in the local part. Comments in an email address are ignored when sending email; for example, john.doe@(comment)example.com, and john.doe@example.com(comment) are both equivalent to john.doe@example.com.

Labels (3)
2 Replies
Anonymous
Not applicable
Author

Hello,

You could reate a user routine and define the function to validate the email address.

Here is a related topic about:https://community.talend.com/t5/Design-and-Development/Email-Validation-in-talend/m-p/119250.

Let us know if it is OK with you.

Best regards

Sabrina

Anonymous
Not applicable
Author

Hi,

 

    Please also check the component tVerifyEmail. It will help in email validation.

 

https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/48qO7UN~cu3N0y6zv4gHsQ

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂