topic Re: Validating International Email and Phone Number in Talend Studio

Validating International Email and Phone Number

AAA999 — Wed, 03 Oct 2018 21:59:44 GMT

I am new to Talend and would like to know if there is any component that can be used to validate International Email and Phone number?

I went through the document and found tVerifyEmail but it is not that helpful for international check.

Has anyone used this concept in there project? If so please provide the steps.

Thanks a Lot.

Re: Validating International Email and Phone Number

TRF — Wed, 03 Oct 2018 22:22:30 GMT

You may use a regex if you want to validate email format https://howtodoinjava.com/regex/java-regex-validate-email-address/
For a deeper analysis and validation, you need to use a service validation. See this link for example https://www.accuwebhosting.com/blog/top-10-bulk-email-list-verification-validation-services-compared/

Re: Validating International Email and Phone Number

AAA999 — Thu, 04 Oct 2018 15:00:56 GMT

Thanks! could you please provide me the job design for Email and Phone and the components?

Thanks a lot

Re: Validating International Email and Phone Number

TRF — Thu, 04 Oct 2018 15:04:12 GMT

You should try by yourself or you will never learn how-to.

Try, fail, retry, ask, retry, win - this is the best way.

Re: Validating International Email and Phone Number

AAA999 — Thu, 04 Oct 2018 15:10:12 GMT

You are right. I have worked with Infa and Infosphere etl tools. Talend is new and due to time crunch needed the solution.

Thanks a lot.

Re: Validating International Email and Phone Number

AAA999 — Thu, 04 Oct 2018 17:00:07 GMT

Could you at least let me know what components would be good? And how the o/p comes back, does it additional o/p coumns the way it does in INFA and InforSphere?

Re: Validating International Email and Phone Number

TRF — Thu, 04 Oct 2018 17:14:19 GMT

Can't understand the 2nd part of your question.

For the rest the components you need depend of the way and/or service you choose for email validation.

If you just want to validate the email format, a little routine is enough.

You can use this one for example:

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();
    }
}

If you decide to call an external service for in deep validation, the components depend on the service constraints.

Internet components such as tHttpRequest, tREST or tSOAP will probably be usefull.

Re: Validating International Email and Phone Number

AAA999 — Thu, 04 Oct 2018 18:24:29 GMT

my second question"

In infosphere they have a in-build component for Address and Name Standardization for USA.

ex: there are 6 columns Addr1,Addr2,City,State,Zip,Name.

When the data is passed through the Standardized component it adds additional cols along with the input cols.

o/p column

6 input cols + additional cols as Address_Formatted, Name_Formatted, Input_Pattern....

Does Talend component behave in similar way.

Thanks

Re: Validating International Email and Phone Number

AAA999 — Tue, 09 Oct 2018 16:29:20 GMT

Still not resolved

Re: Validating International Email and Phone Number

Anonymous — Mon, 03 Dec 2018 08:15:43 GMT

Easiest way to validate and email email address is through email verification service. If there are fewer emails that you need to verify, you can use single validation feature or if ther is a list of email records in 100s or 1000s batch email verification can be used. https://bulkemailverification.com is an unbiased directory of leading email list cleaning services that can come really come handy in selecting the right tools as per your need.

Re: Validating International Email and Phone Number

Anonymous — Mon, 03 Dec 2018 08:31:42 GMT

@AAA999,

Regarding your query about Address standardization, there are components in Talend in also which can be used for address quality.

You can choose any of the components based on your requirement for address data cleanse.

Warm Regards,

Nikhil Thampi

Re: Validating International Email and Phone Number

Anonymous — Mon, 03 Dec 2018 14:12:01 GMT

Using an email verification service like https://debounce.io will easily validate the email address.

Re: Validating International Email and Phone Number

Anonymous — Wed, 17 Jul 2019 09:46:02 GMT

If you are looking for one of the most affordable and accurate Email List Verification service providers then log on to https://deliverbility.com it is the best bulk email verifier with its powerful REST API.

Re: Validating International Email and Phone Number

Anonymous — Mon, 05 Aug 2019 12:44:29 GMT

Yes! you can validate your international and domestic mails as well. For this, you need to get an email verification service which helps you to clean your email list.