Hey ,
i am importing data from a csv file in a loop .it is taking one record in a time and importing it.
i have some dummy data in csv like /,-,'',""
how i can handle it while importing.??
Post one line from your .csv file for testing.
Solution:
FOREACH(ignoreMe IN CASE WHEN line.x <> y THEN [1] ELSE END |
//write your code
)
Here y is equal to say "/"
I recently posted this solution to a topic "CSV column with null values"