Redpoint Data Management™ Documentation
Redpoint Data Management™ Documentation
Breadcrumbs

AO Phone Parse

Overview

Advanced Object (AO) Phone Parse validates and parses North American phone numbers. It accepts a single stream as input and produces one output.

AO Phone Parse configuration parameters

AO Phone Parse has a single set of configuration parameters in addition to the standard execution options.

Parameter

Description

Input phone

Required. Input field containing North American phone number.

  • Default: blank

Output area code

Output. Field to contain area code. Example: (212) 555 1212.

  • Default: PH_AREA_CODE

Output group code

Output. Field to contain group code. Example: (212) 555 1212.

  • Default: PH_GROUP

Output exchange

Output. Field to contain exchange. Example: (212) 555 1212.

  • Default: PH_EXCHANGE

Output extension

Output. Field to contain extension. Example: (212) 555 1212 ext 1023.

Output phone

Output. Field to contain standardized phone number. Example: (212) 555-1212.

Valid phone flag

Output. Field to contain flag indicating valid pattern for input phone number.

  • Default: PH_IS_VALID

Output phone format

Select the format for valid standardized phone number. Defined formats are:

  • (XXX)XXX-XXXX

  • (Default) (XXX) XXX-XXXX

  • (XXX)-XXX-XXXX

  • XXX-XXX-XXXX

  • XXX.XXX.XXXX

  • XXXXXXXXXX

Append original fields

Select to pass all input data (not just input phone) through the macro and append it to the output.

  • Default: yes

Convert letters to numbers

Select to convert  letters included as part of the phone number into their numeric equivalent.

  • Default: no

Append state from area code

Select to use the area code (if exists) to append a state code to the data.

  • Default: no

Configure AO Phone Parse

  1. Select AO Phone Parse.

  2. Go to the Configuration tab on the Properties pane.

  3. Select Input phone and choose the field containing phone numbers.

  4. Optionally, specify alternative field names for the five Output fields.

  5. Optionally, select Output phone format and choose an alternative phone number format.

  6. Optionally, specify an alternative field name for the Valid phone flag.

  7. Configure additional options:

    • Clear the Append original fields check box to suppress input fields on output.

    • Select Convert letters to numbers to convert letters included as part of the phone number into their numeric equivalent.

    • Select Append state from area code to use the area code (if present) to append a state code to the data.

  8. Optionally, go to the Execution tab, and then set Web service options.