MySQL Forums
Forum List  »  Other Migration

CSV IMport Problem
Posted by: Mathias Stern
Date: April 06, 2005 01:00AM

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

Options: ReplyQuote


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.