Phone Number Brackets

Question

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

markshnier__you · Answer

Try this. Assumes a North American starting format.&nbsp;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 +1var 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------------------------------

jessicamatenga · Answer

Thanks Mark that worked perfectly with the mobile numbers. For the phone number is also removed the brackets and hyphen but there is a space after the closing bracket so converted the space appears -
029 7963100 or 5 5937586

Just need to remove the space as well if you can supply the additional formula.
Thanks

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

markshnier__you · Answer

The formula should have removed the space too. Can you post your whole formula?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

jessicamatenga · Answer

Hi MarkHere is the formula for the Phone Number field -var text Tel = ToText([Phone Number]);var text RemoveBracketOne = SearchAndReplace($Tel,"(","");var text RemoveBracketTwo = SearchAndReplace($RemoveBracketOne,")","");var text RemoveHyphen = SearchAndReplace($RemoveBracketTwo,"-","");$RemoveHyphen------------------------------Jessica Matenga------------------------------

markshnier__you · Answer

The spacing in my original post was odd, but you need the last line as well.var text Tel = ToText([Phone Number]);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------------------------------

Forum Discussion

Phone Number Brackets