Output has non-printable chars

[AnishJoseph]

When i export a csv file i get 3 unprintable chars in the beginning of the file - hex values are ef, bb and bf. Am using chrome Version 57.0.2987.133 (64-bit) on OSX. I am using react-csv version 1.0.8
I notice in core.js the following function

var buildURI = exports.buildURI = function buildURI(data, headers, separator) {
  return encodeURI('data:text/csv;charset=utf-8,\uFEFF' + toCSV(data, headers, separator));
};

If i remove the \uFEFF, as given below then the output is as expected without the non-printable chars.

var buildURI = exports.buildURI = function buildURI(data, headers, separator) {
  return encodeURI('data:text/csv;charset=utf-8,' + toCSV(data, headers, separator));
};

Not sure what the issue is.

[jimulle]

I see the same behavior as @AnishJoseph. What is the reason for the \uFEFE?

[nicoleivanov]

Going to comment this here as well, just in case anyone else is following this. @jimulle I just tried to implement the simple example download link and data, and I am having this issue of the 3 unreadable characters appearing in the first cell of the document when it opens in excel from Chrome. Do you know how I can fix this? It works just fine through the link in the examples page http://elegance.abdennoor.com/react-csv/ so I'm not sure why it's not working for me.

[mccabemj]

@nicoleivanov are you using the latest version, since the fix above?

[nicoleivanov]

@mccabemj I believe I was, but I'm no longer using react-csv, so this isn't an issue for me anymore. Thanks!

[pepijnolivier]

@nicoleivanov Could you share what you're now using instead ?

[AnishJoseph]

That project died. 😔

…

On Mon, 5 Aug, 2019, 8:06 PM Pepijn Olivier, ***@***.***> wrote: @nicoleivanov <https://github.com/nicoleivanov> Care to share what you're using instead ? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#22?email_source=notifications&email_token=AAPJIQRYQ66YWCLSCBD22M3QDA3GDA5CNFSM4DJHGOO2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD3SAP7A#issuecomment-518260732>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAPJIQVZXDFRANCFW3C33E3QDA3GDANCNFSM4DJHGOOQ> .

[nicoleivanov]

@pepijnolivier I just made my own implementation. No library, sorry!

[monossido]

Solved by adding
uFEFF={false}