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 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 data command and not > get > >that symbol stored at the end of the text? > > > >Thanks, > >Andrea > > > >__________________________________ > >Do you Yahoo!? > >Yahoo! Finance Tax Center - File online. File on > time. > >http://taxes.yahoo.com/filing.html > > > > > >
__________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
