Forum Discussion

JessicaMatenga's avatar
JessicaMatenga
Qrew Trainee
2 years ago

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

6 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger

    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
    ------------------------------
    • JessicaMatenga's avatar
      JessicaMatenga
      Qrew Trainee
      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's avatar
        MarkShnier__You
        Qrew #1 Challenger
        The formula should have removed the space too. Can you post your whole formula?

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