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. Find more info about substr.

Related Data Pipeline Help Articles

See more