{"id":917,"date":"2018-05-18T08:36:49","date_gmt":"2018-05-18T16:36:49","guid":{"rendered":"http:\/\/blackbirdsolutions.com\/?p=917"},"modified":"2018-05-18T10:43:51","modified_gmt":"2018-05-18T18:43:51","slug":"qvera-getting-rid-of-quotes-from-a-csv-file","status":"publish","type":"post","link":"https:\/\/blackbirdsolutions.com\/?p=917","title":{"rendered":"Qvera: Getting rid of quotes from a CSV file"},"content":{"rendered":"<p>When creating a .csv file in Qvera, the message has double quote text delimiters by default.\u00a0 If you are seeding your message from a SQL query for example, the values will be surrounded by double qotes.<\/p>\n<pre>\"PatientID\",\"PatientName\",\"DOB\",\"Etc\",\"Etc\"<\/pre>\n<p>You can reformat the message by saving the message to a temporary variable, and reformatting it using createCSVMessage to put it back as follows:<\/p>\n<pre><span>var currentMessage = message.getNode('\/');<\/span><span>\r\nmessage = qie.createCSVMessage(false, '\"', ',', 'UTF-8', true);\r\nmessage.setNode('\/', currentMessage);<\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>When creating a .csv file in Qvera, the message has double quote text delimiters by default.\u00a0 If you are seeding your message from a SQL query for example, the values will be surrounded by double qotes. &#8220;PatientID&#8221;,&#8221;PatientName&#8221;,&#8221;DOB&#8221;,&#8221;Etc&#8221;,&#8221;Etc&#8221; You can reformat the message by saving the message to a temporary variable, and reformatting it using createCSVMessage [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-917","post","type-post","status-publish","format-standard","hentry","category-interfaces"],"_links":{"self":[{"href":"https:\/\/blackbirdsolutions.com\/index.php?rest_route=\/wp\/v2\/posts\/917","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blackbirdsolutions.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blackbirdsolutions.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blackbirdsolutions.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blackbirdsolutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=917"}],"version-history":[{"count":3,"href":"https:\/\/blackbirdsolutions.com\/index.php?rest_route=\/wp\/v2\/posts\/917\/revisions"}],"predecessor-version":[{"id":920,"href":"https:\/\/blackbirdsolutions.com\/index.php?rest_route=\/wp\/v2\/posts\/917\/revisions\/920"}],"wp:attachment":[{"href":"https:\/\/blackbirdsolutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blackbirdsolutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blackbirdsolutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}