2 Replies Latest reply on Jul 9, 2015 3:55 PM by john.s

    Help trimming blank from phone number field

    john.s

      Title

      Help trimming blank from phone number field

      Post

      Hi,

      I have an Auto-enter Calculation field for Phone number that looks like this


       "(" &                                                                // start with an open paren sign
      Left ( Filter ( Self; "0123456789" ); 3) &           // fix the area code
      ") " &                                                                 //finish area code with close paren sign and a space
      Middle ( Filter (Self; "0123456789") ; 4; 3) &    //fix the exchange
      "-" &                                                                  //insert a hyphen
      Middle (Filter (Self; "0123456789" ); 7; 4)        //the last 4 digits

      If an operator just enters spaces I want to trim them so the field is blank again...I'm at a loss as how to do that.  I've tied the trim function in a variety of ways but obviously am doing something wrong.

      Any help would be greatly appreciated.