{"id":7149348,"date":"2016-03-08T12:22:14","date_gmt":"2016-03-08T12:22:14","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/problem-with-data-containing-comas-and-line-breaks\/"},"modified":"2016-08-31T14:23:52","modified_gmt":"2016-08-31T14:23:52","slug":"problem-with-data-containing-comas-and-line-breaks","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/problem-with-data-containing-comas-and-line-breaks\/","title":{"rendered":"Problem with data containing comas and line breaks"},"content":{"rendered":"<p>Hello again,<\/p>\n<p>Your plugin is working nice, but there is a kind of bug <strong>in exported CSV file<\/strong> when, for example, in a sent mail via Contact form 7 contains in &#8220;subject&#8221; and (or) in &#8220;message&#8221; <strong>comas<\/strong> or <strong>line breaks<\/strong>.<\/p>\n<p>When importing CSV in excel, <strong>each coma<\/strong> is considered as next column and each <strong>line break<\/strong> as a new line.<\/p>\n<p>So in those cases importing CSV is a real mess\u2026<\/p>\n<p>Regards<\/p>\n<p>https:\/\/wordpress.org\/plugins\/contact-form-advanced-database\/<\/p>\n","protected":false},"template":"","class_list":["post-7149348","topic","type-topic","status-publish","hentry","topic-tag-errors","topic-tag-export-csv","topic-tag-line-break"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/7149348","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\/7149348\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=7149348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}