> >Did you try using a space (' ') as the separator? Did you get an error?And at 7:41 +0000 27/9/06, [EMAIL PROTECTED] wrote: >Yes, I did. ... >So, I need to specify somehow that the fields are delimited by any >number of spaces... One answer of course is grep. However, as far as I can determine, MySQL can only apply grep in the context of a LIKE clause, So... Do it on your text file before importing, if you have a text editor that can handle regular expressions. Just search for / +/ and replace with ' '. Then import using a single ' ' as the 'enclosed by' string. -- Cheers... Chris Due to the nature of my application, this would be rather difficult. I would prefer to import this files directly to mysql. Any other suggestions? Thanks in advance! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
