Category field data import does not work with pipe and semicolon as multivalue separator
When we set wrong multi-values separator from import process then categories data is imported as a string. So let say if we use in the file comma as a separator and in the config we select pipe, then whole category cell content will be imported with commas.