Jeremy,
Apart from this perl of wisdom, how about defining two columns: one a 'temporary' text
field and the other the
'real date column - as proposed, and importing the date-data into MySQL in the
temporary-text field (and leaving
the other/real one empty). Then copy the data out of the tempor
#!/your/path/to/perl
open(OLD, "yourbigfile.txt");
open(FIXED, ">newfile");
while ($line = )
{
$line =~ s/(\d{2})-(\d{2})-(\d{4})/$3-$1-$2/g;
print FIXED $line;
}
Michael
On Tue, 8 Jan 2002, Jeremy Johnstone wrote:
>
> I have a flat text file that is about 820mb I need to import into a d
I have a flat text file that is about 820mb I need to import into a database
that has the dates in the format MM-DD-. MySQL requires dates with the
year first and when I try importing test chunks of the data all I get is
zero's in the date field because of the dates being in the wrong format.
