Phone Number Brackets
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 Mateng...
Forum Discussion
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
------------------------------
029 7963100 or 5 5937586
Just need to remove the space as well if you can supply the additional formula.
Thanks
------------------------------
Jessica Matenga
------------------------------
The formula should have removed the space too. Can you post your whole formula?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- Hi Mark
Here 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
------------------------------- 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
------------------------------- PERFECT!!! Thank you Mark, that works.
------------------------------
Jessica Matenga
------------------------------
