I am using the following query to save my data as csv file on my Desktpo:
CALL apoc.export.csv.query("MATCH (a) RETURN a",
'C:/Users/Raf/Desktop/results.csv', {});
This query returns me a csv where the data are in quotes and the delimeter is a comma ','.
I would like to not have the data in the quotes and have the '|' pipe as a delimiter, how could I do?
You need to pass delimiter in a parameter with key "d".
Ex:
CALL apoc.export.csv.query("MATCH (a) RETURN a",
'C:/Users/Raf/Desktop/results.csv', {d: '|'});