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

[Anonymous]

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-tExtractRegexF..."

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

Incorrect_PhNo.zip

[Anonymous]

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