Skip to main content Skip to complementary content

Formatting US phone numbers

A pipeline with a source, a Phone processor, and a destination.

Before you begin

  • You have previously added the dataset holding your source data.

    Download and extract the file: phone-users.zip. It contains a dataset with user data including names, emails, US phones, etc.

  • You also have created the connection and the related dataset that will hold the processed data.

    Here, a Test dataset.

Procedure

  1. Click Add pipeline on the Pipelines page. Your new pipeline opens.
  2. Give the pipeline a meaningful name.

    Example

    Format US user phone numbers
  3. Click ADD SOURCE to open the panel allowing you to select your source data, here user data entered manually as a test dataset.

    Example

    Preview of a user data sample.
  4. Select your dataset and click Select in order to add it to the pipeline.
    Rename it if needed.
  5. Click Plus and add a Phone processor to the pipeline. The configuration panel opens.
  6. Give a meaningful name to the processor.

    Example

    format US phone numbers
  7. In the Configuration area:
    1. Select Format phone numbers in the Function name list.
    2. Select .phone in the Fields to process list, as you want to format the phone fields.
    3. Select Value in the Use with list and American standard in the Region code list as you want to format the user phones according to US region codes.
    4. Select National in the Format type list as you want to format the phone numbers according to standard local codes.
  8. Click Save to save your configuration.

    Look at the preview of the processor to compare your data before and after the formatting operation.

    Preview of the Phone processor after formatting phone number records.
  9. Click the ADD DESTINATION item and select the dataset that will hold your output data.
    Rename it if needed.
  10. On the top toolbar of Talend Cloud Pipeline Designer, click the Run button to open the panel allowing you to select your run profile.
  11. Select your run profile in the list (for more information, see Run profiles), then click Run to run your pipeline.

Results

Your pipeline is being executed, the user phones have been updated according to local US formatting and sent to the target system you have indicated.

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!