How do I specify the field and array delimiter to neo4j-import as a ASCII character


(Dana Canzano) #1

neo4j-import allows one to initially load a graph.db
via CSV files. There may be times when using a ',' as a field or array delimiter is not appropriate as your data may
contain this character as part of its data. When this is the case you can change the default delimiters via command line
parameters of

--delimiter <delimiter-character>
        Delimiter character, or 'TAB', between values in CSV data. The default option is
--array-delimiter <array-delimiter-character>
        Delimiter character, or 'TAB', between array elements within a value in CSV
        data. The default option is ;.

If you wanted to change the default field delimiter to be the * character then you would need to define

 --delimiter "*"

but it can also be defined as a ASCII character sequence. For example, '*' is decimal 42 on the ASCII chart and the equivalent would

 --delimiter "\042"

The same syntax to specify a ASCII character can also be used for the --array-delimiter.