UNIX for Dummies Questions & Answers

Hello
I am having some problem with my datatable file that I have imported. It was supposed to be tab-separated, however it turned out to be somewhat distorted. For lines in the file got broken inbetween. Now I need to join them back. May I know how I can do it with a AWK or SED or unix.
I would be most grateful if you could help me out here.

my table looks like this:
n-1,"b2172
",NULL,NULL,351,624,360,632,NULL,NULL,37,85,36,84,yes
n-2,"b2716
",NULL,NULL,350,577,343,553,NULL,NULL,37,83,35,82,yes
n-3,"b2980
",NULL,NULL,449,712,431,687,NULL,NULL,37,82,35,82,yes

output should look like this:

n-1,"b2172",NULL,NULL,351,624,360,632,NULL,NULL,37,85,36,84,yes
n-2,"b2716",NULL,NULL,350,577,343,553,NULL,NULL,37,83,35,82,yes
n-3,"b2980",NULL,NULL,449,712,431,687,NULL,NULL,37,82,35,82,yes

Thank you .
greenhorn

Code:

sed -e :a -e '$!N;s/\n"/ /;ta' -e 'P;D' file1

Code:

paste -d '\0' - - < myTable.txt

Hello Bhargav
Thanks for your reply. I tried out the code but it did not change anything in my table. Is there a typo error somewhere?

greenhorn

Hello vgersh99,
Your code works when I drop the zero in '\0'.
Thank you for your help!

happy greenhorn