APOC.load.csv doesn't ignore empty line

Neo4j Graph Platform Procedures & APOC
#1

I have a CSV file to read with empty lines at the end:

,,,,,,
,,,,,,

I can only read from this csv and I can't copy it since it's the source and I'm not the one who create it, and it has to be automated without external software.

Is there an 'ignore empty lines' option with apoc.load.csv? I thought it was like that by default but if it was, not anymore with 4.2.5.

Thanks

#2

Hello Gabriel, I think you can filter the results by adding a WHERE clause after the YIELD in which you test for null values.

(Or rather for empty strings:)

CALL apoc.load.csv("test.csv") 
YIELD map as data, list
WITH data, list
WHERE NOT "" IN list
RETURN data, list
#3

Yeah I did it this way but still apoc.load.csv should remove the empty lines by default as LOAD CSV clause does if I'm right.

It takes more cpu and memory and it's not useful anyway