{"id":431,"date":"2011-01-06T16:13:13","date_gmt":"2011-01-06T21:13:13","guid":{"rendered":"http:\/\/erics-test-lab.com\/?p=431"},"modified":"2011-01-06T16:13:13","modified_gmt":"2011-01-06T21:13:13","slug":"text-formatted-columns-problems-mdash-issue","status":"publish","type":"post","link":"https:\/\/www.esearing.com\/v2010\/2011\/01\/text-formatted-columns-problems-mdash-issue\/","title":{"rendered":"Text formatted columns problems &#8211; Mdash issue"},"content":{"rendered":"<p>I have a SQL SERVER 2005  database filled with VARCHAR, TEXT, and MONEY  data. I export the data via Coldfusion to Excel where the end users like the MONEY values formatted to Number. <\/p>\n<p>Normally not a problem. I used #numericformat(fieldname, &#8216;,.99&#8217;)#  which yield expected results for about 30 records. Then the formatting of the money fields became text in excel. <\/p>\n<p>I changed the money values in the record before and after the problem occurs but that yielded no results. Then I noticed in one TEXT formatted column of the record causing the issue had an M-dash (double dash) as its first character. As soon as I removed the M-dash all worked as expect until a user entered a # sign, but that was easy to figure out. <\/p>\n<p>Mdash is a special character often copied and pasted from email or Word. Treat it as you would $, %, # characters.<br \/>\nIf pasted into a TEXT field  it causes output problems when exporting to excel.<br \/>\nIt affects fields other than the Text field where it occurs,  especially numeric conversions.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mdash in Text field causes output problems when exporting to excel.  <a href=\"https:\/\/www.esearing.com\/v2010\/2011\/01\/text-formatted-columns-problems-mdash-issue\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,21],"tags":[],"class_list":["post-431","post","type-post","status-publish","format-standard","hentry","category-coldfusion","category-problems-fixes"],"_links":{"self":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/posts\/431","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/comments?post=431"}],"version-history":[{"count":0,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/posts\/431\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/media?parent=431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/categories?post=431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/tags?post=431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}