Loading from CSV, WHERE CONTAINS/LIKE

[#1]

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.

[#2 · Accepted solution]

Hello mlindman

it seems that you are quite close, try this:

. . .

WHERE(@1 like '*foo*');

RR