Skip to main content Skip to complementary content

Generating a Job to standardize phone numbers

When you use the Profiling perspective of Talend Studio to analyze phone numbers in a database, you can later generate a ready-to-use Job that will give a correct format to the phone numbers in the specified column.

For further information on phone number indicators, see Phone number statistics.

Before you begin

A column analysis on phone numbers has been created and executed in the Profiling perspective of Talend Studio. For detailed steps on how to create a column analysis, see Defining the columns to be analyzed and setting indicators.


  1. From the Profiling perspective, set Phone Number Statistics indicators on the specified column that holds phone numbers.
  2. Execute this analysis to open the results in the Analysis Results view.
    Table and graphic for the Phone Number Statistics indicator.
  3. In the Phone Number Statistics table and in the Count list, right-click Valid Phone Number Count, Possible Phone Number Count or Well formed National Number Count and then select Generate a standardization phone number job from the contextual menu.

    The Integration perspective opens in Talend Studio showing the generated Job with the tStandardizePhoneNumber component. For more information on this component, see its documentation.

    Job using the tMysqlInput, tStandardizePhoneNumber, and tFileOutputExcel components.

    A node for the newly generated Job shows as well under the Job design folder in the Repository tree view of the Integration perspective.

    In the generated Job, the input and the tStandardizePhoneNumber components are already configured according to the connection you use for the column analysis and according to the column you are analyzing.

    The output component is a file component, but you can replace it with a database output component to write the standardize phone numbers directly in a specific database, for example.

  4. Decide the format to be used to standardize the phone numbers:
    1. Double-click the tStandardizePhoneNumber component to open the Component view.
    2. From the Phone number format for output list, select the format according to which you want to standardize the phone numbers in the selected column.
    3. Save your changes.
  5. Configure the output component:
    1. Double-click the output component and in the File Name field, set the path to the output file that will hold the phone number analysis results.
    2. In the Sheet Name field, set the name of the excel sheet in which you want to write the standardization results.
    3. Save the Job and press F6 to execute it.
      The phone number standardization results are written to the specified excel sheet.
    4. If required, right-click tFileOutputExcel in the generated Job and select Data Viewer.
      A preview of the standardized data is open in the Talend Studio.
      Overview of a preview of analyzed data.

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 – let us know how we can improve!