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


spaces, dots etc. not an issue. There could be something non printing in the original csv that would cause an issue which may have got lost when you copied and pasted here.