September 8th, 1999, 04:22 AM
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?
September 8th, 1999, 02:01 PM
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.
September 8th, 1999, 04:06 PM
I have seen a good way of doing this, by converting the , to a . and multiplying by 1000.