Data Quality - phone number fields with letters in

[Anonymous]

Hi.

I am trying to use Talend DQ in profiling view to do some analysis on some phone numbers. I know we have phone numbers in our database that include letters as well as numbers and I want to count how many times this occurs but cannot get any code I write to work! Can anyone help with any suggestions please?!

Thanks.

JaDoCa

[Anonymous]

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

[Anonymous]

Yeah so in our data base we have a column for phone numbers. If we had the following five entries in here:

017256542

012458789

0124555AA

GJ0125455

012ZQ8478

I would like some code that can look at this and tell me that of the 5 phone numbers we have then 3 of them include letters in them somewhere.

Cheers.

JaDoCa

[Anonymous]

Hi,

    Alphabets in phone numbers means that the number is not valid. Could you please try tStandardizePhoneNumber component which will provide the data in below format.

You can connect the output to a tmap to filter all invalid phone numbers to different flow and store them for further analysis.

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi