Re: GAWK error : replace newline with tab in WinXP ?

[Kam-Hung Soh]

On Mar 26, 1:11 pm, Kam-Hung Soh <kamhung....@gmail.com> wrote:
> On Mar 26, 2:50 am, John Bartley K7AAY <john.bart...@gmail.com> 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>