Databases
StackOverflow2013
Postsdbo
POHow do I awk a unix text file to a predefined html code?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I awk a unix text file to a predefined html code?
    text
    copied!<p>I don't know HTML (HORRIBLY EMBARRASSED but didn't ever have the need to). I am pretty perspicacious when it comes to UNIX however I am horribly confused with this assignment I have. I know what I need to do but am having the hardest time ever getting started.</p> <p>I have the following files in my hwk12 directory:</p> <ul> <li>roster.html</li> <li>roster.txt</li> <li>sample.html</li> <li>sample.txt</li> </ul> <p>The following is the content of the roster.html file:</p> <pre><code>&lt;html&gt; &lt;body&gt; &lt;table border=2&gt; &lt;tr&gt;&lt;th&gt;Name&lt;/th&gt;&lt;th&gt;Username&lt;/th&gt;&lt;th&gt;Email&lt;/th&gt;&lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Nikhil Banerjee&lt;/td&gt; &lt;td&gt;nbanerje&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:zetapsi796@hotmail.com"&gt;zetapsi796@hotmail.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Jeff Nazarian&lt;/td&gt; &lt;td&gt;jnazaria&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:jeff.nazarian@asu.edu"&gt;jeff.nazarian@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Anna Melzer&lt;/td&gt; &lt;td&gt;amelzer&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:anna.melzer@asu.edu"&gt;anna.melzer@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Jose Garcia&lt;/td&gt; &lt;td&gt;jgarcia&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:garcia-j@msn.com"&gt;garcia-j@msn.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Jillian Testa&lt;/td&gt; &lt;td&gt;jtesta&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:jillian.testa@asu.edu"&gt;jillian.testa@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Clayton Lengelzigich&lt;/td&gt; &lt;td&gt;clengelz&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:clayton.lengel-zigich@asu.edu"&gt;clayton.lengel- zigich@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Ashley Bennett&lt;/td&gt; &lt;td&gt;abennett&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:ashley.bennett@asu.edu"&gt;ashley.bennett@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Ann Frost&lt;/td&gt; &lt;td&gt;afrost&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:ann.frost@asu.edu"&gt;ann.frost@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Timothy Whipple&lt;/td&gt; &lt;td&gt;twhipple&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:tweed@asu.edu"&gt;tweed@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Wei Shen&lt;/td&gt; &lt;td&gt;wshen&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:shenwei58@hotmail.com"&gt;shenwei58@hotmail.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Cari Mahon&lt;/td&gt; &lt;td&gt;cmahon&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:cari.mahon@asu.edu"&gt;cari.mahon@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Alberto Salas&lt;/td&gt; &lt;td&gt;asalas&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:alberto2504@msn.com"&gt;alberto2504@msn.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Dorothy Haskett&lt;/td&gt; &lt;td&gt;dhaskett&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:dorothy.haskett@asu.edu"&gt;dorothy.haskett@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Criss Bradbury&lt;/td&gt; &lt;td&gt;cbradbur&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:crissbradbury@hotmaiil.com"&gt;crissbradbury@hotmaiil.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Steve Ellermann&lt;/td&gt; &lt;td&gt;sellerma&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:cis494@ellermann.com"&gt;cis494@ellermann.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Zewdie Bekele&lt;/td&gt; &lt;td&gt;zbekele&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:zewdiea@aol.com"&gt;zewdiea@aol.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Frederic Diziere&lt;/td&gt; &lt;td&gt;fdiziere&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:fsd@asu.edu"&gt;fsd@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Matt Bowes&lt;/td&gt; &lt;td&gt;mbowes&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:matt.bowes@asu.edu"&gt;matt.bowes@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Jasen Meece&lt;/td&gt; &lt;td&gt;jmeece&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:jasen.meece@sun.com"&gt;jasen.meece@sun.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Aaron Carpenter&lt;/td&gt; &lt;td&gt;acarpent&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:aaron.carpenter@asu.edu"&gt;aaron.carpenter@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Binqin Xi&lt;/td&gt; &lt;td&gt;bxi&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:binqin.xi@asu.edu"&gt;binqin.xi@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Yinting Chan&lt;/td&gt; &lt;td&gt;ychan&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:yin.chen@asu.edu"&gt;yin.chen@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Michael Evans&lt;/td&gt; &lt;td&gt;mevans&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:michael.evans@asu.edu"&gt;michael.evans@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Herman Beringer&lt;/td&gt; &lt;td&gt;hberinge&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:jber@cox.net"&gt;jber@cox.net&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Andrew Jolley&lt;/td&gt; &lt;td&gt;ajolley&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:andrew@andrewjolley.com"&gt;andrew@andrewjolley.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Michael Raby&lt;/td&gt; &lt;td&gt;mraby&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:mike1071@yahoo.com"&gt;mike1071@yahoo.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Hajar Alaoui&lt;/td&gt; &lt;td&gt;halaoui&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:hajar6@hotmail.com"&gt;hajar6@hotmail.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Anne Lemar&lt;/td&gt; &lt;td&gt;alemar&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:anne.lemar@asu.edu"&gt;anne.lemar@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Russell Crotts&lt;/td&gt; &lt;td&gt;rcrotts&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:Russell.Crotts@asu.edu"&gt;Russell.Crotts@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Dan Mazzola&lt;/td&gt; &lt;td&gt;dmazzola&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:dan.mazzola@sun.com"&gt;dan.mazzola@sun.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Bill Boyton&lt;/td&gt; &lt;td&gt;bboyton&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:boytonb@earthlink.net"&gt;boytonb@earthlink.net&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <p>The following is the content of the roster.txt file:</p> <pre><code>Whipple Timothy tweed@asu.edu Shen Wei shenwei58@hotmail.com Mahon Cari cari.mahon@asu.edu Salas Alberto alberto2504@msn.com Haskett Dorothy dorothy.haskett@asu.edu Bradbury Criss crissbradbury@hotmaiil.com Ellermann Steve cis494@ellermann.com Bekele Zewdie zewdiea@aol.com Diziere Frederic fsd@asu.edu Bowes Matt matt.bowes@asu.edu Meece Jasen jasen.meece@sun.com Carpenter Aaron aaron.carpenter@asu.edu Xi Binqin binqin.xi@asu.edu Chan Yinting yin.chen@asu.edu Evans Michael michael.evans@asu.edu Beringer Herman jber@cox.net Jolley Andrew andrew@andrewjolley.com Raby Michael mike1071@yahoo.com Alaoui Hajar hajar6@hotmail.com Lemar Anne anne.lemar@asu.edu Crotts Russell Russell.Crotts@asu.edu Mazzola Dan dan.mazzola@sun.com Boyton Bill boytonb@earthlink.net </code></pre> <p>The following is the content of the sample.html file:</p> <pre><code>&lt;html&gt; &lt;body&gt; &lt;table border=2&gt; &lt;tr&gt;&lt;th&gt;Name&lt;/th&gt;&lt;th&gt;Username&lt;/th&gt;&lt;th&gt;Email&lt;/th&gt;&lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Michael Raby&lt;/td&gt; &lt;td&gt;mraby&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:mike1071@yahoo.com"&gt;mike1071@yahoo.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Hajar Alaoui&lt;/td&gt; &lt;td&gt;halaoui&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:hajar6@hotmail.com"&gt;hajar6@hotmail.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Anne Lemar&lt;/td&gt; &lt;td&gt;alemar&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:anne.lemar@asu.edu"&gt;anne.lemar@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Russell Crotts&lt;/td&gt; &lt;td&gt;rcrotts&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:Russell.Crotts@asu.edu"&gt;Russell.Crotts@asu.edu&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Dan Mazzola&lt;/td&gt; &lt;td&gt;dmazzola&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:dan.mazzola@sun.com"&gt;dan.mazzola@sun.com&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;Bill Boyton&lt;/td&gt; &lt;td&gt;bboyton&lt;/td&gt; &lt;td&gt;&lt;a href="mailto:boytonb@earthlink.net"&gt;boytonb@earthlink.net&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <p>The following is the content of the sample.txt file:</p> <pre><code>Raby Michael mike1071@yahoo.com Alaoui Hajar hajar6@hotmail.com Lemar Anne anne.lemar@asu.edu Crotts Russell Russell.Crotts@asu.edu Mazzola Dan dan.mazzola@sun.com Boyton Bill boytonb@earthlink.net </code></pre> <p>I'm not asking for someone to do this for me because I LOVE UNIX and I want to learn it myself. Everytime I look at this HTML code I am confusing the #$$#&amp; out of myself. I need help getting started.</p> <p>The homework prompt is the following:</p> <p>You are to write a nawk(1) script called ~/hwk12/mk_html.awk that converts a text file (sample.txt and roster.txt) to an html page that a web browser can read. I have given you the output in the file sample.html which is reproduced below (notice how each level of indentation is two spaces deep):</p> <p>Again, I don't want someone to do this for me. Im just confused as to how data in the text file will append to the HTML table without the actual HTML code. Can someone please help me get started?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload