how to avoid newline character?

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

print out rows from array/perl

I have created 2 columns: col1 varchar(20) col2 varchar(20) when I add content to the columns it looks like this for example: col1 contentA NULL contentB Now when I try to print out the content in Perl using this code: while($dirty_words = $sth-fetchrow_array) { print "$dirty_wordsbr\n"; }