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

[John Bartley K7AAY]

On Mar 25, 8:30 pm, Kam-Hung Soh <kamhung....@gmail.com> wrote:
> 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.)
<snip>

> 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>

I appreciate the suggestion, but that led to a new problem, four gawk
error messages:

gawk: cmd. line:1: ORS=1?,:\t
gawk: cmd. line:1:             ^ parse error

               (The caret lines up with the comma on the first line.)


gawk: cmd. line:1: ORD=1?,:\t
gawk: cmd. line:1:              ^ backslash not last character

                (The caret lines up with the backstroke on the third
line)

I'll take another look at this later today.
Again, thank you; appreciate the effort.