Using LOAD DATA

I have a db and wish to load data into it from a tab delimited text file. One of the fields contains price info such 1,234 or 2,423. I am trying to load it into a field of type INT(5). But all I get is the numeral before the column. Everything else gets dropped. Is there an easy way to get this price data into the database or must I eliminate all commas from prices?

Unless I'm mistaken you will have to eliminate all commas from that field if you wish to have the result stored as an int.

I have seen a good way of doing this, by converting the , to a . and multiplying by 1000.