Strip out the 'n' \ new line out of the echo to a file [closed]

manpreet Best Answer 2 years ago

I have a bash script that pulls a bit of text from an external MySQL database. Most of the times it are 4 lines, each one on his own line. This text (in total) has to be placed into a file. The script now pulls the information from the MySQL database, puts it in a variable. Then I echo it in a file:

echo -ne $variable > file

The problem is that the 'n' gets also printed/echo'ed to the file. Like this:

here is sentence number 1
nthere is number 2
nals here comes number 3
nlast but not least number 4

somehow there is a kind of new-line that is printed and I need to have the text without the 'n'.

EDIT 1 - copy of the Bash script:

#!/bin/bash

DBHOST='xx.xxx.xx.xxxx'
DBUSER='xxxxxx'
DBPASS='xxxxxx'
DBNAME='xxxxxx'

mysql -N -u$DBUSER -p$DBPASS -h$DBHOST -D$DBNAME -e "SELECT id,vhost FROM test;" | while read id vhost;
do
echo -ne $vhost > vhost
done

For obvious reasons I removed the database details.

EDIT 2 - I am using the following Bash and Ubuntu version:

Ubuntu: 12.04.2 Bash: 4.2.25