Forum Discussion

Qrew Trainee

Re: Phone Number Brackets

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
------------------------------

4 Replies

MarkShnier__You
Qrew Legend
3 years ago
The formula should have removed the space too. Can you post your whole formula?

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- JessicaMatenga
  Qrew Trainee
  3 years ago
  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
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    3 years ago
    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
    ------------------------------