3 Replies Latest reply: Oct 23, 2015 5:46 AM by Dave Bingley RSS

    Sense - using match function

    Dave Bingley

      Team

       

      What have I done wrong here please...

       

       

      [handles],
      if(match([knockers], 'slimline_urn','Slim'),

          if(match([knockers], 'urn','Standard'),

          if(match([knockers], 'urn_with_spyhole','Standard (V)'),

          if(match([knockers], 'slimline_urn_with_spyhole','Slim (V)'),

          if(match([knockers], 'ingot','Ingot'),

          if(match([knockers], 'horsetail','Horsetail'),

          if(match([knockers], 'no_knocker','None','None')))))))),

      [letterplates]

       

      Thanks in advance

       

      Bing

        • Re: Sense - using match function
          Liron Baram

          you misplaced the brackets

          if(match([knockers], 'slimline_urn'),'Slim',

              if(match([knockers], 'urn'),'Standard',

              if(match([knockers], 'urn_with_spyhole'),'Standard (V)',

              if(match([knockers], 'slimline_urn_with_spyhole'),'Slim (V)',

              if(match([knockers], 'ingot'),'Ingot',

              if(match([knockers], 'horsetail'),'Horsetail',

              if(match([knockers], 'no_knocker','None'),'None')))))))

          • Re: Sense - using match function
            Dave Bingley

            Sussed it myself people

             

            [handles],
            if([knockers] = 'slimline_urn','Slim',

                if([knockers] = 'urn','Standard',

                if([knockers] = 'urn_with_spyhole','Standard (V)',

                if([knockers] = 'slimline_urn_with_spyhole','Slim (V)',

                if([knockers] = 'ingot','Ingot',

                if([knockers] = 'horsetail','Horsetail',

                if([knockers] = 'no_knocker','None','None'))))))) as [knockers],

            [letterplates],