John,
Thanks a bunch! I had tried this once and it did not seem to work,
so I assumed I did not understand the LINE END character function.
After getting your message, I thought it worth another try since I thought
that should be the answer as well. Worked like a charm! I must have
had a typo or something in my first try.
Again, thanks and it works great. 12,000 rows loaded in less time than
I could look at my watch!
My first
-------------- Original message --------------
From: John Minyo II <[EMAIL PROTECTED]>
> At 05:19 PM 1/9/2006, you wrote:
> >I am under a bit of a time constraint and hope someone can help me out
> >quickly.
> >
> >I have a 852 EDI document being sent to me that uses a ~ as the end of
> >line character. I need to load this into a table one line at a time, but
> >do not remember how to make Rbase read the ~ as the end of record. If I
> >bring up the file in the RBEditor, it is all in one long string. (The file
> >can be mega bytes in size)
> >
> >Any help will be greatly appreciated.
> >
> >Thanks,
> >
> >-Bob
>
>
> Bob,
>
> Have you tried changing your LINEEND character setting to the ~ for loading
> the data?
>
> John
>
