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