On Mar 26, 1:11 pm, Kam-Hung Soh <[EMAIL PROTECTED]> wrote: > 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>
Correction: use three double-quotes to escape a double-quote. gawk "ORS=1?""",""":"""\t"""" %1.tsv > %1.csv -- Kam-Hung Soh <a href="http://kamhungsoh.com/blog";>Software Salariman</ a>
