topic Email Validation in talend in Talend Studio

Email Validation in talend

Anonymous — Sat, 16 Nov 2024 06:26:11 GMT

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.

Re: Email Validation in talend

Anonymous — Tue, 19 Mar 2019 08:11:45 GMT

Hello,

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

Let us know if it is OK with you.

Best regards

Sabrina

Re: Email Validation in talend

Anonymous — Tue, 19 Mar 2019 09:20:46 GMT

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 🙂