Question: I'm importing CSV file in MySQL database with ColdFusion, my code works fine but I have one issue. I want to ignore double quotes around the words. So my csv looks like this: "John","Mark","Peter" . Every time after I insert CSV in database I'm getting double quotes around my words. Is there any command in ColdFusion that I can use to prevent double quotes? I tried to use trim but that did not work. If you know anything that can help please let me know.

Answer: 
Loop over the fields and do something along these lines:

```
<cfset field = reReplace(field, '^"', '')>
<cfset field = reReplace(field, '"$', '')>
<cfset field = replace(field, '\"', '"', 'ALL')>

```

This will remove the surrounding quotes and unescape quotes within the field.
Well you can replace the double quotes by using the conveniently-named & imminently guessable [`replace()`](https://wikidocs.adobe.com/wiki/display/coldfusionen/Replace) function. However... you might not want to get rid of all of them. Double-quote string delimiters are how CSV deals with data values with embedded commas or new line characters in them (see the [CSV RFC](https://www.ietf.org/rfc/rfc4180.txt)). If you know you won't have any of those, I can see no harm in getting rid.

That said... a better way might be to not put the quotes in there in the first place, rather than having them and needing to get rid of them. This is the approach *I'd* take with this, if poss.