how to avoid newline character?

2001-04-21 Thread Andreas Antes
When I load data into a mysql table from a simple tab delimeted textfile I prepared in a regular texteditor (notepad) using the "load data infile" command there is a newline character at the end of the text in every last column. How do I get rid of this newline character or are there alternative

Re: how to avoid newline character?

2001-04-21 Thread Paul DuBois
At 5:53 AM -0700 4/21/01, Andreas Antes wrote: When I load data into a mysql table from a simple tab delimeted textfile I prepared in a regular texteditor (notepad) using the "load data infile" command there is a newline character at the end of the text in every last column. How do I get rid of