
Signature
Bob Quintal
PA is y I've altered my email address.
>The rows have the CrLf embedded in the quoted strings. That
>means they were placed in the original file.
Sorry, what is meant by 'original file'? The file is created
on-the-fly using ls command to do a dir of the unix box
current directory - that listing is what's being written to
the local PC during the process. Strangely, out of 851
root-level dirs jointly containing 24000+ 2nd level dirs,
only about 2000 entries (rows which ultimately become
records) are comprised of multiple CRLF-separated lines
that are enclosed in dbl-quotes. 90% of the lines are not
enclosed in dbl-quotes but DO have carriage returns &
line feeds at the ends of the lines. They have to wrap
somehow.
>Try to redo the import specification to set the "Text
>Delimiter" value to the double-quote.
BillCo - 13 Mar 2006 12:14 GMT
Sounds like the problem is in the unix box...
you could fix the text with vba before you import to fix it - remove
dbl qoutes that come directly after vbcrlf and remove vbcrlfs that
proceed quotes. then remove all remaining quotes.
but i'd fix the output from the unix box - or throw it back to the
person who is responsible for it.
Bob Quintal - 13 Mar 2006 13:10 GMT
>>The rows have the CrLf embedded in the quoted strings. That
>>means they were placed in the original file.
> Sorry, what is meant by 'original file'? The file is created
> on-the-fly using ls command to do a dir of the unix box
> current directory - that listing is what's being written to
> the local PC during the process.
Then it is the directory structure that contains some
descriptors or metadata which contains the double quotes..
Strangely, out of 851
> root-level dirs jointly containing 24000+ 2nd level dirs,
> only about 2000 entries (rows which ultimately become
[quoted text clipped - 6 lines]
>>Try to redo the import specification to set the "Text
>>Delimiter" value to the double-quote.

Signature
Bob Quintal
PA is y I've altered my email address.
Randy Harris - 13 Mar 2006 14:51 GMT
>> The rows have the CrLf embedded in the quoted strings. That
>> means they were placed in the original file.
[quoted text clipped - 11 lines]
>> Try to redo the import specification to set the "Text
>> Delimiter" value to the double-quote.
You've got something else going on. The ls command won't put double
quotes around anything. FTP, in ASCII mode, will sometimes however, add
CR-LF every 255 characters.

Signature
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.