1 Reply Latest reply: Aug 22, 2013 10:32 AM by Gysbert Wassenaar RSS

    Case Select

    Jerry Helms

      How would I accomplish the non-working pseudocode below in QV?

       

      Load

        URL,

           (Select Case URL

                Case wildmatch(URL,'*abc*) : ABC

                Case wildmatch(URL,'*def*') : DEF

                Case wildmatch(URL,'*ghi*') : GHI

                Default: XYZ

           End Select) as ProductCode

      From AnyTable.qvd(qvd);