topic Re: Email Validation in talend in Talend Studio

Email Validation in talend

Anonymous — Wed, 09 May 2018 09:39:36 GMT

how to verify that the email address column's data is having @ or [.] if not then load rejected data on diferent table.

please help!!

Re: Email Validation in talend

Anonymous — Wed, 09 May 2018 09:58:17 GMT

Hi
Create a user routine and define the function to validate the email address, and call the user routine on tFilterRow to filter the valid email address. If you just want to simply check the email address if it is having @ or ., using this expression on tFilterRow:
input_row.emailColumn.contains("@")||input_row.emailColumn.contains(".")

Regards
Shong

Re: Email Validation in talend

TRF — Wed, 09 May 2018 10:07:36 GMT

@vitspltalend, having an @ or a . (dot) is not enough to be a valid email.

The following "@@@@...." matches the rule but is not a valid email address.

As suggested by @shong, use a user defined routine to check the email validity.

It should look like this one:

package routines;
import java.util.regex.*;
public class checkEmail {
    public static boolean isEmailValid(String email) {
    	String regex = "^[\\w!#$%&'*+/=?`{|}~^-]+(?:\\.[\\w!#$%&'*+/=?`{|}~^-]+)*@(?:[a-zA-Z0-9-]+\\.)+[a-zA-Z]{2,6}$";
    	Pattern pattern = Pattern.compile(regex);
    	Matcher matcher = pattern.matcher(email);
    	return matcher.matches();
    }
}

Re: Email Validation in talend

Anonymous — Wed, 09 May 2018 10:14:33 GMT

That's a good shout by @TRF. As an addition to that (he should get the solution on this), Talend supplies the Apache Commons libraries which have hundreds of really useful, efficient and community (Java community) checked/built solutions. The Apache Commons Validator library comes with a whole host of validation methods for Emails, Phone Numbers, URLs, etc, etc. You should take a look.

Re: Email Validation in talend

Anonymous — Wed, 09 May 2018 10:24:19 GMT

thanks @shong and @TRF, actually i am new in talend so, can you please tell me the whole process like where i can create user defined routine and which component i can use?

Re: Email Validation in talend

TRF — Wed, 09 May 2018 10:31:15 GMT

In the Repository, right click on Code, create a folder (here called "custom") then right click on "custom" and create a routine then past the code from my previous answer.

Here is what your screen should look like:

Re: Email Validation in talend

Anonymous — Wed, 09 May 2018 11:52:18 GMT

hello shong can u plz tell me what is the process to call the user routine on tFilterrow to filter the valid email address?

Re: Email Validation in talend

Anonymous — Wed, 09 May 2018 11:58:11 GMT

hello @TRF can u plz tell me what is the process to call the user routine on tFilterrow to filter the valid email address?

Re: Email Validation in talend

Anonymous — Wed, 09 May 2018 11:59:35 GMT

This tutorial (https://help.talend.com/reader/jomWd_GKqAmTZviwG_oxHQ/O_Vnk3B4SbKXtF5gTQl2Gg) shows how to use the Advanced Mode (which is what you will need). To point to the routine, you will need to use something like this....

routines.YourRoutineClass.yourRoutineMethod(parameters)

Re: Email Validation in talend

TRF — Wed, 09 May 2018 12:04:24 GMT

Use tFilter Advanced mode to write the appropriate expression such as:

checkEmail.isEmailValid(row1.yourEmailField)

Re: Email Validation in talend

Anonymous — Wed, 10 Oct 2018 07:00:25 GMT

Hello TRF,

Thanks for the Email Validation code.

I am using for the same reason in my peoject but there is something going wrong with this. getting error.

will you help me ?

Error : The public type checkEmail must be defined in its own file

screen shot is attached.

Error in Code..PNG

Re: Email Validation in talend

MaheswarReddy — Tue, 22 Oct 2019 13:29:01 GMT

Hi @Shri_Kul1 ,

You need to give the same name of the routine and the class ,

You have given as different names

CheckeMail

checkEmail

Please update , it will work.

Thanks,

Mahesh