replace new line character between double quotes with \n in ubuntu

Question

Data sample input:

Name    mobile  url message text
test11  1234567890  www.google.com  "Data Test New
Date:27/02/2020
sample1: 1bags
sample2: 20bags
Regards
The test user user user Sangha
Ph:091 : 123456789"
test12  1234567891   www.google.com  hello

My output should be

Name    mobile  url message text
test11  1234567890  www.google.com  "Data Test New\nDate:27/02/2020\nsample1: 1bags\nsample2: 20bags\nRegards\nThe test user user user Sangha\nPh:091 : 123456789"
test12  1234567891  www.google.com  hello

I have used the below command but it's not working

awk '!/"$/{sub(/$/,"\\n");printf "%s",$0;next}1' file

I have used several other commands as well, but none of them are working in my case

Does this answer your question? [Count number of line in txt file when new line is inside data](https://stackoverflow.com/questions/65035029/count-number-of-line-in-txt-file-when-new-line-is-inside-data) — Ryszard Czech, Nov 30 '20 at 22:35

anubhava · Accepted Answer · 2020-11-30T16:19:35.330

0

Using gnu-awk, you may do this:

awk -v RS='"[^"]*"' '{gsub(/\r?\n/, "\\n", RT); ORS=RT} 1' file

Name    mobile  url message text
test11  1234567890  www.google.com  "Data Test New\nDate:27/02/2020\nItems: 1\nTotal: 3\nRegards\nABC DATa\nPh:091 : 123456789"
test12  1234567891   www.google.com  hello

Code Demo

edited Nov 30 '20 at 16:19

answered Nov 30 '20 at 14:59

anubhava

761,203
64
569
643

after using your script I am getting below output Name mobile url message text Ph:091 : 123456789"user Sanghagle.com "APMC BANGALORE ARRIVALS test12 1234567891 www.google.com hello – user13000875 Nov 30 '20 at 15:11
it's working there then why it's not working from my terminal. – user13000875 Nov 30 '20 at 15:19
gawk is already installed in my system . When I run command sudo apt-get install gawk then I am getting gawk is already the newest version – user13000875 Nov 30 '20 at 15:32
it's giving GNU Awk 4.1.3, API: 1.1 (GNU MPFR 3.1.4, GNU MP 6.1.0) – user13000875 Nov 30 '20 at 16:00
Do `cat -A file` to check if input has any DOS line ending i.e. `^M` characters. – anubhava Nov 30 '20 at 16:01
Yes it has ^M. But my user can upload file from any OS. only my server will be ubuntu – user13000875 Nov 30 '20 at 16:12
1

Then you can use: `awk -v RS='("[^"]*")' '{gsub(/\r?\n/, "\\n", RT); ORS=RT} 1' file` – anubhava Nov 30 '20 at 16:14
1

it's works perfectly . Thank you so much .You are such a helpful person – user13000875 Nov 30 '20 at 16:19

replace new line character between double quotes with \n in ubuntu

1 Answers1