{"id":4024226,"date":"2013-08-13T10:26:04","date_gmt":"2013-08-13T10:26:04","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/exporting-to-csv-separators-broken-by-custom-fields\/"},"modified":"2016-08-21T03:53:25","modified_gmt":"2016-08-21T03:53:25","slug":"exporting-to-csv-separators-broken-by-custom-fields","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/exporting-to-csv-separators-broken-by-custom-fields\/","title":{"rendered":"Exporting to csv separators broken by custom fields?"},"content":{"rendered":"<p>I&#8217;m trying to export the posts table to CSV but on PhP My Admin default settings it comes out as a broken CSV file.<\/p>\n<p>I know it&#8217;s something to do with separators and chracters I&#8217;m using in my posts and custom fields.<\/p>\n<p>Does anyone know how to fix this please?<\/p>\n<p>What separators can I use that won&#8217;t be affected by any of the content I have in my posts.<\/p>\n<p>Thanks<\/p>\n","protected":false},"template":"","class_list":["post-4024226","topic","type-topic","status-closed","hentry","topic-tag-csv","topic-tag-export-csv"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4024226","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4024226\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=4024226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}