topic Re: Incorrect telephone numbers in Talend Studio

Incorrect telephone numbers

Anonymous — Mon, 01 Oct 2018 11:21:29 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

Anonymous — Mon, 08 Oct 2018 11:11:52 GMT

Hi There

I had attached a sample job for your requirement.

for more info refer "https://community.talend.com/t5/Design-and-Development/collect-the-reject-record-from-tExtractRegexFields-Component/td-p/64367"

Expr: "^[0-9]*$"

Incorrect_PhNo.zip

Re: Incorrect telephone numbers

Anonymous — Thu, 11 Oct 2018 05:34:10 GMT

Hi Adam,

There is a help document to standardize the phone number in help.talend.com. Could you please refer this and let us know your experience in using this component?

https://help.talend.com/reader/OE_HqPbtpUhLImlWQRUjgA/ETixpFy4DBzOw1phHWTQMw

Warm Regards,

Nikhil Thampi