I have a tab delimited text file where the 23rd column with string has \n in it which causes it to break to the next line.

I opened the text file in vi and enabled white space characters and I can see that the values in DESCR2 field have blank lines breaking the string.

The string is contained within tab delimited characters and I am trying to remove the \n and have the string concatenate to ABC 123 while still in 1 field .

I have tried `tr -d '\n' < file.txt` but that would make all the lines into 1 line. I want to only remove \n\n from that column.

I also tried `sed 's/\n\n//' file.txt` but it has no effect. I am able to search and replace \n\n in vi but I can't get the same result with sed.

Example: 

 \t"ABC\n
 \n
 123"\t

Desired output:

 \t"ABC 123"\t