Incorrect telephone numbers

Four Stars

Incorrect telephone numbers

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

Four Stars

Re: Incorrect telephone numbers

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]*$"

 

Employee

Re: Incorrect telephone numbers

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog