THAT WORKED! Thanks - that was too easy!
Andrea
--- Kevin Carlson <[EMAIL PROTECTED]> wrote:
> Try this (untested) :
>
> update table set column=LEFT(column,
> LENGTH(column)-1)
>
>
>
> Andrea Broerman wrote:
>
> >I have successfully loaded data from a
I am running in Windows.
--- dan orlic <[EMAIL PROTECTED]> wrote:
> sounds like the difference between a windows system
> and a linux
> system. If you are doing the
> load on a linux system, a simple dos2unix
> should set you
> straight.
>
> dan
>
>
I have successfully loaded data from a comma separated
file (CSV) into a table, but the last field in each
record appears to have a little square symbol at the
end of the text which I assume is either an end of
line or new line symbol. Is there a way to get rid of
that? How can I run the load dat
