Hallo Jigal,
Op 22 Jun 05 schreef Jigal van Hemert aan <[EMAIL PROTECTED]:
JvH> What about reading the data into the table and storing the
JvH> 'amount' in varchar for now. Then you can run an update query in
JvH> UPDATE `table` SET `amount`= REPLACE( `v_amount`, ',' , '.'),
JvH> `v_amount`
Hallo Anoop,
Op 22 Jun 05 schreef Anoop kumar V aan Jigal van Hemert <[EMAIL PROTECTED]>,:
AkV> Alternatively, you can parse the text files using application logic
AkV> (java, c++, etc) and then after extracting (and cleaning) your data
AkV> insert them into mysql.
I had been thinking about t
Alternatively, you can parse the text files using application logic
(java, c++, etc) and then after extracting (and cleaning) your data
insert them into mysql.
matter of fact we do something very similar - read from a host of text
files - massage the data and then send them to be inserted into the
From: <[EMAIL PROTECTED]>
> That's what I Ntried to say, yes :) The main problem is the decimal comma
> in the amounts.
What about reading the data into the table and storing the 'amount' in
varchar for now. Then you can run an update query in which you replace the
decimal comma with a decimal poi
Hello Anoop,
On 22 Jun 05, Anoop kumar V wrote to All:
AkV> Are u saying that u have data in a text file and you need to parse
AkV> this and insert them into mysql?
That's what I Ntried to say, yes :) The main problem is the decimal comma
in the amounts.
Regards,
Hans.
jdh dot be
Hallo,
I get data with a format that I can't choose. The fields are enclosed
in double quotes ("), separated by commas (,). The main problem is that
some fields contain amounts with a decimal comma. I have not found a
way yet to load these data properly. Could somebody help me please?>
Groetjes,
