Phone number formatting

Data Pipeline

If you have a phone number column in the format 5556667777, but you want the format (555) 666-7777, you can use the data pipeline.

Using an “edit column” step, select a custom formula and using the function substr, you can enter: (‘   substr(“Phone”,0,4)   ’)’   ’ ‘   substr(“Phone”,4,3)   ’-‘   substr(“Phone”,7,5)

You would replace (Phone) with the name of the column you are editing.

Our data pipeline uses SQLite. More info about Substr can be found here.

Related Data Pipeline Help Articles

See more