1 Reply Latest reply: Nov 15, 2011 4:04 AM by Roland Kunle RSS

    Loading from CSV, WHERE CONTAINS/LIKE

    Mika Lindman

      I'm loading rows from csv

      1/1/2011;1;foobar

      1/2/2011;2;quickbrownfox

       

      How can I filter the rows during load so that the text field has to have certain value?

       

      LOAD

          @1,

          @2,

          @3

      FROM

           [..\data.csv]

      WHERE

          ???

       

      I've tried

      @3 LIKE '%foo%'

      @3 CONTAINS('foo')

      @3 = '*foo*'

       

      But can't figure out the right syntax. Thanks for any help on this.