CSV IMport Problem
Sorry for the double post (already posted in newbie section) - but I need an answer!!! Maybe I can get it here ...
H!!
How can I correctly import a csv-file (comma separated file) into a MySQL database if decimal-values in the csv-file are separated with a "," (comma) instead of a "." (point)?
Example:
1234,56 (56 is "lost" after importing)
Notes:
*) The numbers are imported into a decimal(18,3) field
*) I can't change the csv-files before importing (find & replace)
*) The fields in the csv-file are separated with a ";" (semikolon).
E.G.:
ID,Name,Number
1;"hugo";1234,23; <--- line in the csv-file
Thank you, Mac
Subject
Views
Written By
Posted
CSV IMport Problem
4825
April 06, 2005 01:00AM
2509
May 19, 2005 11:22PM
2596
December 12, 2005 11:15AM
2352
December 13, 2005 02:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.