AnsweredAssumed Answered

Help.  Smart quotes and apostrophes in CSV export file are causing weird ’ characters

Question asked by TomDalton on Oct 6, 2010
Latest reply on Oct 7, 2010 by rjlevesque

Title

Help.  Smart quotes and apostrophes in CSV export file are causing weird ’ characters

Post

I'm exporting a "product feed" from our FMP database.  We export as CSV and then upload that CSV file to "FeedPerfect" and then FeedPerfect sends it out to 4 or 5 shopping comparison sites  (including goggle base).

I've tried every type of encoding in our CSV file.  I've tried Mac, UTF-8, UTF-16, ASCII and most of the others.  I've tried opening the CSV file in bbedit and use their "straighten quotes" to remove any smart quotes.  Nothing works.  The uploaded file always ends up encoding problems which cause apostrophes turned into "’" and other issues.

What else can be done to fix this problem?

Thanks, Tom

Outcomes