do not load empty rows - another question

[cscherer]

Hello,

I´ve got another question regarding the load of empty rows.

I´ve got this script:

Directory;

LOAD date,

     amount,

     site

FROM

test_emptyrows.csv

(txt, codepage is 1252, embedded labels, delimiter is ';', msq)

Where Len ((date ) >0);

In my data source there are rows without date but with values in the other fields. This rows I do not want to load. What do I have to change?

Thanks,

cscherer

[swuehl · Accepted solution]

Try

...

Where Len (trim(date)) >0;

[cscherer]

thanks!