Skip to main content

Default columns

The following table presents details about the default columns provided by tStandardizePhoneNumber.

Tip: In addition to these default columns, you need to define more columns alongside in order for this component to receive the corresponding input data.

Columns

Description

StandardizedPhoneNumber

This column presents the standardized phone numbers.

IsValidPhoneNumber 1

This column indicates whether a phone number processed is recognized as valid.

IsValidPhoneNumberForRegion 2

This column indicates whether a phone number is recognized as valid for a certain region.

IsPossiblePhoneNumber

This column indicates whether a phone number processed is supposed to be valid.

IsAlreadyStandard

This column indicates whether a phone number processed is already standardized after comparing it with the output standardized phone number.

PhoneNumberType

This column indicates the type of a processed phone number, such as fixed line, toll free, etc.

ErrorMessage

This column presents the relative error message if a phone number is unrecognizable.

1 As IsValidPhoneNumberForRegion was added from 7.3 onwards, when you run a Job created in a previous version, the results in IsValidPhoneNumber may be different than the previous versions.

2 From Talend Studio 7.3, when you use a Job created in a previous version, you do not have this column.

1, 2 These columns can have the same input data but the results are different. For example: A phone number is valid, true returned in IsValidPhoneNumber, but the country code is wrong, false returned in IsValidPhoneNumberForRegion.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!