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:
You would replace “Phone” with the name of the column you are editing.
Our Data Pipeline uses SQLite. Find more info about substr.