2 Replies Latest reply on Oct 1, 2014 5:53 AM by philmodjunk

    fine-Tuning my DB

    Gilo

      Title

      fine-Tuning my DB

      Post

      Hi

      I achieved the point where i want to make my DB even more effective, so I have some problems:

      1. Text editing 
      I copy/paste phone number from another DB and there i get different formats:

      123456 or 12-23-45 or 12 23 34 

      Is there a way to always get 12 23 34?

       

      2. If I copy/paste data on a windows, it uses the wrong font. Is there a way, that FM always displays the same font??

       

       

      Thank you in advance

        • 1. Re: fine-Tuning my DB
          raybaudi

          Hi

          put this calculation in the auto-enter option of that field:

          Let (
          T = Filter ( TextFormatRemove ( Self ) ; 1234567890 ) ;
          Replace ( Replace ( Replace ( Replace ( T ; 3 ; 0 ; " " ) ; 6 ; 0 ; " " ) ; 9 ; 0 ; " " ) ; 12 ; 0 ; " " )
          )

          and remember to unflag the box: "Do not replace existing value..."

          • 2. Re: fine-Tuning my DB
            philmodjunk

            TextFormatRemove ( Self )

            Can be used by itself on any field where you do not want text formats to be pasted into a field along with the data.