Skip to main content
Skip table of contents

AO Phone Parse

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:

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

  • (XXX) XXX-XXXX

  • (XXX)-XXX-XXXX

  • XXX-XXX-XXXX

  • XXX.XXX.XXXX

  • XXXXXXXXXX

Default: (XXX) XXX-XXXX.

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, and then go to the Configuration tab on the Properties pane.

  2. Select Input phone and select the field containing phone numbers.

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

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

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

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

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.