Hi,
I have multiple CSV files exported by the same application in one export session and with the same delimiter. The CSV reader does recognize delimiter automatically for all but one file. Even when I enter the delimiter at the reader "delimiter character" it is not recognized. I'm wondering what might be different with that file.
I noticed all files have UTF-8 encoding but not the one in question. When I convert to UTF-8 (Notepad++) it still doesnt work. I have no idea which other file properties cause that the file being treated differently. I also copied the delimiter character from the CSV file and pasted it to the readers "delimiter character" - still the same.
Any ideas what the reason could be?
FME 2019.
Many thanks, Rob