2 Replies Latest reply on Nov 6, 2014 10:45 AM by Kirk_1

    Exact match

    Kirk_1

      Title

      Exact match

      Post

      I have several hundred vendors. I want to make sure i get the exact one. I copied and pasted the name from my vendor file.

      Will this script step give me USF Reddaway for example if I have USF Reddaway and Bob Reddaway trucking? 

      If i'm doing a found set i put =USF Reddaway and i only get USF Reddaway....

      Case (
                   $carrier = "FEDEX PRIORITY" ; "FXFE";
                   $carrier = "FEDEX ECONOMY"; "FXFE";
                   $carrier = "YRC" ; "RDWY";
                   $carrier = "ESTES EXPRESS LINES" ; "EXLA";
                   $carrier = "USF REDDAWAY" ; "RETL"
      )

        • 1. Re: Exact match
          philmodjunk

          What you posted is not a script, but a calculation.

          It will return "RETL" for USF Reddaway, but returns null for "Bob Reddaway trucking".

          This looks like data that might be better handled with a look up table of carrier names and associated acronyms. Then, adding/removing/modifying data becomes a data entry task on that table (no FMP developer needed) instead of a design change to the calculation (developer needed).

          • 2. Re: Exact match
            Kirk_1

            Thats a great point.

            Thank you