0 Replies Latest reply on Nov 22, 2011 9:44 AM by PeterCole

    Export as CSV and escaped quotes

    PeterCole

      Title

      Export as CSV and escaped quotes

      Post

      Item: double quote in field content.

      Does anyone know how to deal with the fact that Filemaker will export quoted data by adding an additional quote regardless of whether you escape the quote  with a backslash or not. I've gotten the exact same results in FMP9 and trial 11

      Example: (in text field - fields are enclosed in double quotes [omitted here])

      8-12" CAT-safe  will export in CSV as 8-12"" CAT-safe

      8-12\" CAT-safe will export in CSV as 8-12\"" CAT-safe

      Thus it is particularly useless for importing into MySQL tables as the field count will fail and the import will terminate. At the moment I am forced to do a global search and replace in Homesite 5 to remove the extra quote. Kind of time consuming when dealing with a 1500 record table.

      Any suggestions most welcome.

      Regards,]

      Peter