Using Format Phone Number

Sean Leoszko

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:

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

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

This produces a cleaner output:

How do others format phones?

Clinton Jones

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