Incorrect telephone numbers

[Anonymous]

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

[Ganshyam]

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

[Anonymous]

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

[Ganshyam]

Hello Adam,

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

Regards

Ganshyam

[Anonymous]

Thank you for the confirmation Ganshyam. Very useful!

[Anonymous]

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