Daniel, is it that the columns in the file are separated by a variable
number of spaces? Or is it that the columns are fixed-width,
therefore the number of spaces varies with length of data? If the
file is fixed-width, the SQL below ought to work pretty well.
Either way, your situation is not t
> >Did you try using a space (' ') as the separator? Did you get an error?
And at 7:41 + 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 determ
Pe 27 Sep 2006, la 10:29, Chris <[EMAIL PROTECTED]> a scris:
>Did you try using a space (' ') as the separator? Did you get an error?
And at 7:41 + 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...
Pe 27 Sep 2006, la 10:29, Chris <[EMAIL PROTECTED]> a scris:
>
>[EMAIL PROTECTED] wrote:
>> 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
