We are checking the copy command to load file. These files are using ‘|-|’ as a field separator.
Checked and observed that MapD support single character string as delimeter.
delimiter: A single-character string for the delimiter between input fields. Default: “,” (a CSV file)
Now a days it is very difficult to use single character as delimiter. As chances are high this value will use anywhere in text field.
Please let us know is it any way possible to use combination of 2-3 character to use as delimiter.