How to replace comma in .xlsx file in ColdFusion?
<p>I have excel file that can contain commas in some fields. This can cause problem if I want to use <code>cfspreadsheet</code> to convert my file to <code>csv</code>. I was wondering if there is the way to <code>replace</code> or <code>convert</code> all commas with the <code>\</code>. After I replace all commas then I will be able to use <code>cfspreadsheet</code> to create <code>csv</code>. Here is my code how I read my file:</p>

<pre><code>&lt;cfspreadsheet action = "read" format="csv" src="filePath\myFile.xlsx" name="csvvar"&gt;
</code></pre>

<p>If anyone can help with this problem please let me know. Thank you.</p>