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.jerryp
ournelle.com/view/
> > > currentview.html) and the physics are using
the collected wisdom of
> > > Fred on Everything (http://www.fredoneve
rything.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?""",""":"&quo
t;"t"""" %1.tsv > %1.csv
>
> --
> Kam-Hung Soh <a href="http://k
amhungsoh.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.
|
