Change delimiter type when exporting data into csv

[dfritsch]

Hello,

is it possible to change delimiter type when exporting data from Neo4j into csv file?

My current export query use the comma "," as delimiter between the requested information (EntityLabels and Entity):
<CALL apoc.export.csv.query("MATCH (e:entity) WHERE e.name = 'Daniel' RETURN labels(e) AS EntityLabels, e.name AS entity", "results.csv", {})>

However I would need to use vertical bar "|" (as a delimiter) instead. I tried to run the following query but it did not help:
<CALL apoc.export.csv.query("MATCH (e:entity) WHERE e.name = 'Daniel' RETURN labels(e) AS EntityLabels, e.name AS entity", "results.csv", {d: '|'})>

Can I kindly ask you if it is possible to export data from Neo4j using a different delimiter? If so, are there any suggestions how to run such query?

Please note I am currently using Neo4j 4.0.4.

Thank you very much for any help!

Daniel

[mckenzma]

I am not entirely sure. Have you checked the documentation here? I didn't see anything about changing the file delimiter.

Is there a particular reason | works better than ,? I am just curious as to why you would prefer that separator.

[bratanic_tomaz]

When in doubt, always check the source code

It seems that the correct parameter name is actually delim judging by this code:

github.com

neo4j-contrib/neo4j-apoc-procedures/blob/e9961ed100d33ea9f1d78498adcc1c2bd903e4a5/core/src/main/java...

public ExportFormat getFormat() { return format; }

public Set<String> getCaption() { return caption; }

public CypherFormat getCypherFormat() { return cypherFormat; }

public ExportConfig(Map<String,Object> config) {
    config = config != null ? config : Collections.emptyMap();
    this.silent = toBoolean(config.getOrDefault("silent",false));
    this.delim = delim(config.getOrDefault("delim", DEFAULT_DELIM).toString());
    this.arrayDelim = delim(config.getOrDefault("arrayDelim", DEFAULT_ARRAY_DELIM).toString());
    this.useTypes = toBoolean(config.get("useTypes"));
    this.caption = convertCaption(config.getOrDefault("caption", asList("name", "title", "label", "id")));
    this.nodesOfRelationships = toBoolean(config.get("nodesOfRelationships"));
    this.bulkImport = toBoolean(config.get("bulkImport"));
    this.separateHeader = toBoolean(config.get("separateHeader"));
    this.format = ExportFormat.fromString((String) config.getOrDefault("format", "cypher-shell"));
    this.cypherFormat = CypherFormat.fromString((String) config.getOrDefault("cypherFormat", "create"));
    this.config = config;
    this.streamStatements = toBoolean(config.get("streamStatements")) || toBoolean(config.get("stream"));