Using Format Phone Number

Options
Sean Leoszko
Sean Leoszko Experian Contributor
edited January 5 in General

I was wondering how everyone uses the function Format Phone Number in Aperture. For myself, I am to keep it simple but wish to avoid error messages being shown for non-phone numbers.

Below is a set of various data that may exist in the customer's dataset:

image.png

If you use Format Phone by itself, you will receive some errors for non-phone numbers:

image.png

In order to avoid these errors being shown to the user I will either return the original unformatted value or a null value.

image.png

This produces a cleaner output:

image.png

How do others format phones?

Tagged:

Comments

  • Clinton Jones
    Clinton Jones Experian Elite
    Options

    I like this approach, a good use of a variable in the function builder.

    Is there a reason you posted this on the internal only ? @Sean Leoszko

Categories