I'm used to hammering all kinds of data into MySQL. Often I do it with a PHP (or Perl) script that handles this kind of thing well. However, often my data originates on a PC (don't ask), so I run it through MS Excel. Excel (and OpenOffice, I presume) has good tools for parsing text files, and can then export to a tab-separated file.
Ugly, but as I said my data comes in all kinds of nasty formats, such as web pages. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 27, 2006 3:20 AM > To: mysql@lists.mysql.com > Subject: fields separator > > hi, everyone! > I have a text file like this: > 10:10:00 0 0 1 99 > 10:20:00 0 0 1 99 > 10:40:00 11 3 4 83 > 11:00:00 1 1 2 97 > 11:05:00 2 1 1 96 > > I need to load this file into a table, but I cannot figure > out the syntax of LOAD DATA INFILE command. As you can see, > the fields are separated by a variable number of blank spaces > (not tabs). How can I do this? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
