I considered perl but it is quite some time since I used it so I had been wondering if there was a way do what I wanted from within MySQL. Having said that it has taken about an hour for me to relearn some perl tricks and get the problem sorted so perhaps I should have just tried straight off instead of trying to cheat :)
Anyway, thanks for your help guys, CM PS Rick, I don't have much experience with AWK, always been one of those things I need to look into. -----Original Message----- From: Bradley Brown [mailto:[EMAIL PROTECTED]] Sent: 30 May 2002 00:27 To: Cameron Murdoch Cc: [EMAIL PROTECTED] Subject: Re: Filemaker Pro and Dates Do you have any experience with Perl? Perhaps a quick script would convert your tab delimited files to the proper format? Bradley Cameron Murdoch wrote: > Hi all, > > I apologise if this question has been asked recently; I have checked > the list archives and could not see anything. This is my problem: > > I am trying to convert and import a fairly convoluted Filemaker Pro 5 > database to MySQL. I have exported the filemaker records as tab > delimited files and have managed to load them in to MySQL without too > much problem. However I have one issue: Dates. Of course MySQL stores > dates in YYYY-MM-DD whilst filemaker uses DD-MM-YYYY and so when I > import my delimited text file MySQL interprets the dates incorrectly. > I can't seem to find a way of changing the date format in Filemaker, > nor can I figure out how to get MySQL to convert the dates into it's > format. Any help would be greatly appreciated and I apologise if this > is something simple but this is my first entanglement with databases. > > I am using MySQL 3.23.49 running on FreeBSD 4-STABLE. MySQL was > compiled from the FreeBSD port. > > Thanks for your help, > > Cameron > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php