Exporting double-byte character set -- garbled characters | Community
Skip to main content
Frank_Elley
Level 3
Nov 28, 2018 5:52 PM UTC
Solved

Exporting double-byte character set -- garbled characters

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
Nov 28, 2018 5:59 PM UTC

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

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

View reply

6 replies

SanfordWhiteman
SanfordWhiteman
Level 10
Dec 3, 2018 11:23 PM UTC

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.

Translate
SanfordWhiteman
SanfordWhiteman
Level 10
Nov 28, 2018 7:05 PM UTC

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

Translate
SanfordWhiteman
SanfordWhiteman
Level 10
Nov 28, 2018 6:29 PM UTC

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".

Translate
SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
Nov 28, 2018 5:59 PM UTC

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

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

Translate
Frank_ElleyAuthor
Level 3
Dec 3, 2018 11:40 PM UTC

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.

Translate
SanfordWhiteman
SanfordWhiteman
Level 10
Dec 4, 2018 12:06 AM UTC

OK, thanks for the update. What I suspected.

Translate
Terms & ConditionsAccessibility statement

Loading footer...