Neo4j: How to have '|' as delimeter when export data in csv?

Question

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?

Answer 1

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: '|'});