topic Re: Incorrect telephone numbers in Data Quality

Incorrect telephone numbers

Anonymous — Tue, 02 Oct 2018 11:20:19 GMT

Hi All,

I'm complacently new to Talend and my first challenge is to check how many telephone numbers are incorrectly populated. In specific, I'm looking to find out, how many telephone numbers consist of letters rather than numbers (or a mixture). For example I'm looking for mistakes such as: "0a123356789", "dont want to give number", "USA 01234567", etc.

Thank you in advance for your help.

Adam

Re: Incorrect telephone numbers

Ganshyam — Fri, 05 Oct 2018 08:41:00 GMT

Hello,

You mean to say that if the telephone number consists of any alphabetic then it is invalid and you want the message as "dont want to give number" ?

Regards

Ganshyam

Re: Incorrect telephone numbers

Anonymous — Fri, 05 Oct 2018 09:50:09 GMT

Hello Ganshyam,

Thank you for looking into my question. Yes, I want to flag as invalid, if telephone columns are populated with alphabetic characters.

Since I've asked the question though, I was able to find out the way to do what i wanted. Basically, i set up a pattern definition to '[[:alpha:]]' and did a telephone column analysis.

If you have any other ways to do the same, please let me know.

Adam

Re: Incorrect telephone numbers

Ganshyam — Fri, 05 Oct 2018 10:47:33 GMT

Hello Adam,

Yes, that is the only way..using StringHandling.ALPHA option available in tmap component under expression builder.

Regards

Ganshyam

Re: Incorrect telephone numbers

Anonymous — Fri, 05 Oct 2018 11:53:04 GMT

Thank you for the confirmation Ganshyam. Very useful!

Re: Incorrect telephone numbers

Anonymous — Tue, 09 Oct 2018 08:42:13 GMT

Hi,

If you are using a subscription Product of Talend, there is a component which will check and standardise the telephone numbers. The component name is tStandardizePhoneNumber

https://help.talend.com/reader/hCrOzogIwKfuR3mPf~LydA/8_Q4WAzPdmlNfO5mdguPVg

If you get a chance, please try this option also.

Warm Regards,

Nikhil Thampi