0 Replies Latest reply: Mar 19, 2013 5:19 PM by Stuart Wenzel RSS

    Exclude data in script

    Stuart Wenzel

      I cannot figure out how to exclude names with 'coach' in them:

       

      Table:

      LOAD

                1 as Counter,

                Name

      From file.txt (txt, codepage is 1252, embedded labels, delimiter is ',', msq)

      WHERE Name <> '*coach*';