On Mar 26, 2:50 am, John Bartley K7AAY <[EMAIL PROTECTED]> wrote: > awk 'ORS=%NR%1?",":"\t"' %1.tsv > %1.csv > > This line of code, adapted > fromhttp://www.ee.ucl.ac.uk/~hamed/misc/awk1line.txt > fails for me while running GNUWIN32 gawk 3.1.0 and I would appreciate > guidance from y'all in finding a fix. > > I am trying to take a three line file and turn it into a one-line, tab- > separated file, so I can (later on) concatenate multiple files into > one CSV for import into Excel. > > Thank you kindly in advance. > > The TSV files look something like this: > > XY_12345_Acme_Blinder_Coughdrop-Optimal > 9 > This test will run Lorem ipsum dolor sit amet, consectetuer adipiscing > elit. Fusce a diam. Etiam sapien pede, placerat quis, malesuada in, > eleifend quis, velit. Praesent imperdiet cursus odio. Praesent vel > lorem. Pellentesque dignissim, felis non euismod rhoncus, felis pede > condimentum lacus, ac accumsan mi leo sit amet lacus. Donec porta nunc > ut sapien. Morbi pede. Nulla tincidunt nisi mollis augue. Praesent > dapibus cursus tellus. Sed accumsan dui sed metus. Morbi lacus. Nunc > placerat arcu tincidunt turpis. Proin tristique ullamcorper velit. > Proin id justo egestas erat interdum volutpat. Sed sodales massa sit > amet orci. Duis hendrerit volutpat velit. Aenean vel libero. > Suspendisse potenti.##Test will run the following sequence:#1. Run in > circles#2. Scream#3. And shout###The following are is a more in-depth > look at what each of Praesent tincidunt egestas nulla. Nullam non mi. > Ut tellus ipsum, molestie fringilla, eleifend non, pulvinar vel, > sapien. Nullam et mi nec neque tempus iaculis. Sed quam. Aenean orci > nulla, sodales et, pulvinar sodales, sagittis vel, turpis. Aliquam > massa quam, porttitor vitae, rhoncus ac, volutpat at, sem. Cras sed > lorem. Mauris faucibus erat non neque. Nunc bibendum mattis mi. > Quisque elementum diam at lectus. (http://www.jerrypournelle.com/view/ > currentview.html) and the physics are using the collected wisdom of > Fred on Everything (http://www.fredoneverything.net/ > FOE_Frame_Column.htm).#The tests are run in Ut arcu. Nulla venenatis > egestas risus. Vestibulum nec ligula. Aenean adipiscing risus quis > libero vulputate rutrum. Proin sagittis orci non mi. Mauris magna. > Aliquam malesuada lectus vitae pede. Integer lacus risus, volutpat > sed, ultrices in, venenatis et, libero. Praesent euismod mauris id > turpis hendrerit egestas. Mauris tristique. Aliquam vel enim posuere > nisi vehicula laoreet. Integer tempus vestibulum odio. Donec et quam. > Maecenas lacinia nulla sed est. Donec mollis ligula sed tellus. > Phasellus quis eros a sem vulputate eleifend. Phasellus sagittis felis > id tellus. Nunc condimentum ultricies sem. ##Test 1:# How many Aggies > does it take to screw in a lightbulb? #Sed blandit, tellus non cursus > blandit, est justo sollicitudin lectus, vel mollis lectus magna ac > pede. Aliquam aliquam lorem sed erat. Quisque rutrum, enim sit amet > ornare varius, dui libero lacinia orci, non iaculis mi sapien non > urna. Sed massa ante, elementum ut, posuere quis, interdum eget, > ipsum. Duis blandit condimentum elit. Aliquam volutpat iaculis leo. > Suspendisse nibh nibh, dignissim cursus, elementum sed, convallis eu, > metus. Phasellus vel magna. Aenean nulla nisi, rhoncus non, egestas > non, commodo bibendum, pede. Aliquam justo. Aliquam sapien tortor, > placerat accumsan, auctor porta, rhoncus sed, tortor. Ut tempus. > Curabitur vitae lectus quis lectus venenatis posuere. Curabitur > venenatis. Donec elementum eros. Praesent eget ligula nec metus > molestie hendrerit. Sed at nisi.
When I tried your script on Windows XP using GNU Awk 3.1.3, I found this error: gawk: cmd. line:1: 'ORS=1?,:\t' gawk: cmd. line:1: ^ invalid char ''' in expression If that is the problem you encountered, you have to escape the double- quote mark in a double-quoted string using the "^" (double-quote caret double-quote) sequence. (It's as awkward as it sounds.) Try: gawk "ORS=1?"^"","^"":"^""\t"^""" %1.tsv > %1.csv Regards, -- Kam-Hung Soh <a href="http://kamhungsoh.com/blog";>Software Salariman</ a>
