6 Replies Latest reply on Oct 11, 2010 11:28 AM by rjlevesque

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

    TomDalton

      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