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.)
>
> Try:
>
> gawk
"ORS=1?"^"","^"":"^&
quot;"t"^""" %1.tsv > %1.csv
>
> Regards,
>
> --
> Kam-Hung Soh <a href="http://k
amhungsoh.com/blog">Software Salariman</
> a>
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>
|
