Exporting double-byte character set -- garbled characters

Forum|Forum|7 years ago
November 28, 2018
4 replies
4455 views

Can't get any hits in KB or forums for "double byte" (any variation), so posting this question:

Our team occasionally needs to export a Marketo smart list that contains double-byte characters. The character set is correct in Marketo. And in most cases, the double-byte characters come through correctly when the export is opened in Excel. But some characters are garbled, and we can't detect where the issue is occurring and how to solve it. Any advice?

Thanks!

Marketo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by SanfordWhiteman

To be clear, are you exporting as CSV, or as Excel-flavored CSV?

(Excel-flavored has a UTF-8 BOM. CSV does not.)

SanfordWhitemanAccepted solution

Level 10

To be clear, are you exporting as CSV, or as Excel-flavored CSV?

(Excel-flavored has a UTF-8 BOM. CSV does not.)

F

Frank_ElleyAuthor

Level 3

After some travel delays and timezone differences, I was able to catch up with the Asia team. Indeed, choosing the "Windows Excel 2007" format was the key. I had thought they'd tried all the options, but evidently the missed this at the bottom of the Format selection list. Thanks for pointing us in the right direction.

SanfordWhiteman

Level 10

OK, thanks for the update. What I suspected.

SanfordWhiteman

Level 10

Also, the reason "double-byte" wouldn't come up in a search -- well, until now -- is that you're probably talking about both double and triple-byte storage in UTF8, so it's easier to just talk about "Unicode" or "UTF8" or "UTF16".

SanfordWhiteman

Level 10

@Frank Elley pls return to the thread when you can to read replies.

SanfordWhiteman

Level 10

Again, @Frank Elley, please return to the thread you opened 5 days ago which has had Community responses since just a few minutes after you posted.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded