<p>I'm importing some data from a <code>CSV</code> file, and numbers that are larger than <code>1000</code> get turned into <code>1,100</code> etc. </p>

<p>What's a good way to remove both the quotes and the comma from this so I can put it into an <code>int</code> field?</p>

<p><strong>Edit:</strong> </p>

<p>The data is actually already in a MySQL table, so I need to be able to this using SQL. Sorry for the mixup.</p>

You could use this perl command.
```
```
Perl -lne 's/[,|"]//; print' file.txt > newfile.txt
```
```
You may need to play around with it a bit, but it should do the trick.