Replace \n(new line) with space in bash

bash sed tr
Prometheus picture Prometheus · Aug 29, 2016 · Viewed 11.5k times · Source

I am reading some sql queries into a variable from db and it contains new line character (\n). I want to replace \n (new line) with space. I tried solutions provided on internet but was unsuccessful to achieve what I want. Here is what tried :

strr="my\nname\nis\nxxxx";
nw_strr=`echo $strr | tr '\n' ' '`;
echo $nw_strr;

my desired output is "my name is xxxx" but what I am getting is "my\nname\nis\nxxxx". I also tried other solution provided at internet, but no luck: 

nw_strr=`echo $strr | sed ':a;N;$!ba;s/\n/ /g'`;

Am I doing something wong?

Answer

Cyrus picture Cyrus · Aug 29, 2016

With bash:

Replace all newlines with a space:

nw_strr="${strr//$'\n'/ }"

Replace all strings \n with a space:

nw_strr="${strr//\\n/ }"

Related questions

How to use sed to replace the first space with an empty string

I am having trouble loading a space delimited text file into a table. The data in this text file is generated by teragen, and hence, is just dummy data, where there are only 2 columns, and the first column has values …

Read More
SED/tr etc.. : How to comment out a line that contains "string" in a file?

my file contains lines such as these: -A INPUT -m state --state NEW -m tcp -p tcp --dport 2000 -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 2001 -j ACCEPT -A INPUT -m state --state NEW -m …

Read More
Removing punctuation and tabs with sed

I am using the following to remove punctuation, tabs, and convert uppercase text to lowercase in a text file. sed 's/[[:punct:]]//g' $HOME/file.txt | sed $'s/\t//g' | tr '[:upper:]' '[:lower:]' Do I need …

Read More