Converting a text file to HTML


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Converting a text file to HTML
# 1  
Converting a text file to HTML

Hi,
I need to convert a text file formatted like this ("tshark -z conv,ip" output) to HTML:

Code:
=====================================================================================================
IPv4 Conversations
Filter:<No Filter>
                                               |       <-      | |       ->      | |     Total     |
                                               | Frames  Bytes | | Frames  Bytes | | Frames  Bytes |
192.168.1.246      <-> 192.168.1.135            2       276       1        60       3       336
192.168.1.255      <-> 192.168.1.167            2       184       0         0       2       184
192.168.1.255      <-> 192.168.1.99             1       265       0         0       1       265
192.168.1.255      <-> 192.168.1.164            1       126       0         0       1       126
10.0.0.255      <-> 10.0.0.250            1       126       0         0       1       126
192.168.1.255      <-> 192.168.1.41             1        92       0         0       1        92
=====================================================================================================

Preferably the rows and the columns would be in a table so the data is nicely aligned. Are there any tools that would allow me to do this from a script? ...or do I need to use sed/awk? If so, how?

Thank you! Smilie
# 2  
Let me be more specific. I can display the data I need by doing:

Code:
awk '//{print $1,$3,$5,$7,$9}' file.txt |grep -v "|" |grep -v "Filter" |grep -v "IPv4" |grep -v "="

Now I would like to add the following HTML tags:

<TR><TD> in front of $1
</TD><TD> in front of $2, $3, $5, $7, $9
</TD></TR> at the end of each line (after $9)

How would I go about doing that?

Thank you! Smilie
# 3  
Here's what I did and it actually works. It's very inefficient though:

Code:
awk '//{print $1,$3,$5,$7,$9}' file.txt |grep -v "|" |grep -v "Filter" |grep -v "=" |grep -v "IPv4" |sed 's/^/<TR><TD>/' |sed 's" "</TD><TD>"' |sed 's" "</TD><TD>"' |sed 's" "</TD><TD>"'|sed 's" "</TD><TD>"' |sed 's"$"</TD></TR>"g' >file.htm

Can you guys help me shorten it?

Grazie! Smilie
# 4  
This should work:
Code:
awk -v a="<TR><TD" -v b="</TD><TD>" -v c="</TD></TR>" 'BEGIN{print "<html><table>"}/^[0-9]/{print  a$1b$3b$5b$7b$9c}END{print "</table></html>"}' file.txt > file.htm


Last edited by danmero; 10-29-2008 at 08:23 PM..
# 5  
Sweet!
Thank you! Smilie
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #420
Difficulty: Medium
JavaScript supports much of the structured programming syntax from C (e.g., if statements, while loops, switch statements, do while loops, etc.).
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Converting text file to html page

Hello Everyone, I have the following text file with the each field separated by newline Text file P file1-en-us_US-20170718T150157Z.json Wed 19 Jul 2017 06:10:13 AM EDT P file2-en-us_US-20170718T160150Z.json Wed 19 Jul 2017 06:10:13 AM EDT P file3-en-us_US-20170718T163218Z.json Wed... (9 Replies)
Discussion started by: nextStep
9 Replies

2. Shell Programming and Scripting

Converting data for text file to csv

Gents Using the script attached (raw2csv). i use to create the file .csv.. The input file is called 201.raw. Kindly can you check if there is easy way to do it. The script works fine but takes a lot time to process Thanks for your help (8 Replies)
Discussion started by: jiam912
8 Replies

3. Shell Programming and Scripting

Format problem while converting text file to csv

Hi , I need a help in following scenario.I tried searching in google but couldn't able to find the exact answer. Sorry if i am re-posting already answered query. While i am trying to convert into log file into csv i couldn't able to get the format which i am looking for. I converted file... (4 Replies)
Discussion started by: varmas424
4 Replies

4. Shell Programming and Scripting

Converting text file in a matrix

Hi All, I do have a file with many lines (rows) and it is space delimited. For example: I have a file named SR345_pl.txt. If I open it in an editor, it looks like this: adfr A2 0.9345 dtgr/2 A2 0.876 fgh/3 A2 023.76 fghe/4 A2 2345 bnhy/1 A3 3456 bhy A3 0.9876 phy A5 0.987 kdrt A5... (9 Replies)
Discussion started by: Lucky Ali
9 Replies

5. UNIX for Dummies Questions & Answers

Converting a text file with irregular spacing into a space delimited text file?

I have a text file with irregular spacing between values which makes it really difficult to manipulate. Is there an easy way to convert it into a space delimited text file so that all the spaces, double spaces, triple spaces, tabs between numbers are converted into spaces. The file looks like this:... (5 Replies)
Discussion started by: evelibertine
5 Replies

6. Shell Programming and Scripting

Converting columns of a text file.

Not sure the most effient way to do this. I have figiured out how to extract columns with shell script, but not sure how to convert This is what I have... NEWDNS 04-Jun-2011 06:00:59.762 10.220.136.217 crl.verisign.com This is what I need.... Change date, remove mil seconds,... (1 Reply)
Discussion started by: mrlayance
1 Replies

7. Shell Programming and Scripting

Sybase Interface file and converting in text format.

Does anyone knows how to decode the address in interface file using shell , i have done it using perl but can it be done in shell. master tli tcp /dev/tcp \x00021004ac1414230000000000000000 query tli tcp /dev/tcp \x00021004ac1414230000000000000000 (0 Replies)
Discussion started by: dinjo_jo
0 Replies

8. Shell Programming and Scripting

Converting HTML data into a spreadsheet

Hi, I have a perl script that prints some data in the form of a table (HTML table) Now, I want to be able to convert this data into a report on an Excel sheet. How can I do this? Regards, Garric (4 Replies)
Discussion started by: garric
4 Replies

9. UNIX for Dummies Questions & Answers

How do I extract text only from html file without HTML tag

I have a html file called myfile. If I simply put "cat myfile.html" in UNIX, it shows all the html tags like <a href=r/26><img src="http://www>. But I want to extract only text part. Same problem happens in "type" command in MS-DOS. I know you can do it by opening it in Internet Explorer,... (4 Replies)
Discussion started by: los111
4 Replies

10. UNIX for Dummies Questions & Answers

Converting HTML to CSV

Hi, I need to convert a relatively large html file (1.5megs) into CSV under Unix. How would I be able to do this? Much thanks. (3 Replies)
Discussion started by: Jexel
3 Replies

Featured Tech Videos