How to load data from txt file§

[6681510]

hi i have a text file like this
NAME PRICE

FSCCLIWEWW 2,89
SFGAAJAKLK 10,290
SHAGAJHGAS 80,54
|
TAB

NOW I WANT TO LOAD THIS DATA IN TO MYSQL TABLE

LOAD DATA LOCAL INFILE "C:/MST_FI_TEST.TXT" INTO TABLE TEST
FIELDS TERMINATED BY '\t';

now the problem is after runing this script all the DATA IS TRUNCATED from the price column because there is a ',' in the price so how can replace a comma with '.' the file so big and i have many file if i try to replace in all the files it can take much .

 

[elsenorjose]

Is the data enclosed in quotes? If so, try changing your query to

LOAD DATA LOCAL INFILE "C:/MST_FI_TEST.TXT" INTO TABLE TEST
FIELDS TERMINATED BY '\t'
ENCLOSED BY '"';