When using LOAD CSV one can define the field delimiter used, for reference the default is the comma (,) character.

If you want to override the default this can be accomplished via the parameter FIELDTERMINATOR, for example:

Note: that for Aura the file must be publicly hosted HTTP/HTTPS or FTP

This will read a file named actors.csv and expect each field is delimited by the semi-colon character ';'

One can also define the FIELDTERMINATOR as a hexadecimal representation of its ASCII character. This can be helpful if you have chosen a field delimiter as a non-printable character, for example

the usage of '\u' as a FIELDTERMINATOR needs to be a 4 character zero padded value. In the above example the field terminator is now defined to be hexadecimal value 80, which is decimal character 128 of the ASCII extended characters and represents the non printable padding character.