Phone Number Brackets

Question

Hi
Is there a formula that removes the brackets from a phone number when a csv is exported from Quickbase? Other than changing the field to numeric

------------------------------
Jessica Matenga
------------------------------

MarkShnierYou · Answer

Try this. Assumes a North American starting format.

var text Tel = ToText([My Phone# field]);

var text RemoveBracketOne = SearchAndReplace($Tel,"(","");
var text RemoveBracketTwo = SearchAndReplace($RemoveBracketOne,")","");
var text RemoveHyphen = SearchAndReplace($RemoveBracketTwo,"-","");

$RemoveHyphen

phone# to 10 digits prefixed with +1

var text Tel = ToText([Mobile for Drug test Notifications]);

var text RemoveBracketOne = SearchAndReplace($Tel,"(","");
var text RemoveBracketTwo = SearchAndReplace($RemoveBracketOne,")","");
var text RemoveHyphen = SearchAndReplace($RemoveBracketTwo,"-","");

SearchAndReplace($RemoveHyphen," ","")

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community