3 Replies Latest reply on Oct 15, 2014 10:55 AM by Nehme

    Auto Correct Option

    Nehme

      Hello,

       

      Is there any method to perform an auto-correct of a word (or auto-replace a word by another, or replace an abbreviation by an expression).

       

      Thanks

        • 1. Re: Auto Correct Option
          Mike_Mitchell

          Take a look at the Substitute ( ) function. Use in conjunction with the Auto-enter options - calculation to achieve the desired result.

          • 2. Re: Auto Correct Option
            alquimby

            Nehme,

             

                 If you are talking about auto correcting a small number of values, you could use something like this:

             

            Trim ( Substitute ( AddressStreet ; [ "¶" ; "" ] ; [ "." ; "" ] ;

             

            [ "Avenue" ; "Ave" ] ; [ "Road" ; "Rd" ] ; [ "Drive" ; "Dr" ] ; [ "Street" ; "St" ] ; [ "Boulevard" ; "Blvd" ] ; [ "Pkway" ; "Parkway" ] ; [ "Pkwy" ; "Parkway" ] ; [ "Pwy" ; "Parkway" ] ; [ "Pk" ; "Pike" ] ; [ "Ln" ; "Lane" ] ; [ "Ct" ; "Court" ] ; [ "Pt" ; "Point" ] ) )

             

                 Be sure "Do Not replace existing value of field..." is unchecked.

             

            Al Quimby

            • 3. Re: Auto Correct Option
              Nehme

              Thank you for your help