Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Extract both contents from a html file and do printing

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extract both contents from a html file and do printing
# 1  
Old 10-22-2015
Extract both contents from a html file and do printing
Hi there,

Print IP Address:
Code:
 grep 'HostID     :' 10.244.9.124\ nessus.html | awk -F '<br>' '{print $12}' | tr -s ' ' | awk -F ':' '{print "<tr><td>" $2 "</td><td>"}'

Print Respective Ports:
Code:
 grep 'classsubsection\|./tcp\|./udp' 10.244.9.124\ nessus.html | grep -v 'h2.classsubsection {\|Port\|0/'  | sed 's/<[^>]*>//g'

Print IP Address:
Code:
10.244.9.124

Print Respective Ports:
Code:
25/tcp       53/tcp     53/udp     88/tcp     123/udp   135/tcp     137/udp   139/tcp     389/tcp       445/tcp                 464/tcp   593/tcp     636/tcp     1025/tcp     1027/tcp       1044/tcp     1058/tcp     1063/tcp     1067/tcp     1115/tcp     2301/tcp       2381/tcp                                                   3181/tcp   3268/tcp       3269/tcp     3389/tcp

I would like to print out in this format say if I would have multiple files to get the IP Addresses and its Ports
Code:
<table border='1'>
<tr><td>10.244.9.124</td><td>25/tcp</br>53/tcp</br>53/udp</br>88/tcp</td></tr>
<tr><td>10.244.9.125</td><td>53/tcp</br>53/udp</br>88/tcp</td></tr>
.........................................
</table>

Another seperate issue is how to search for ip address in the html file instead of using
Code:
  grep 'HostID     :'

Last edited by alvinoo; 10-22-2015 at 06:12 AM.. Reason: wrong ip address
# 2  
Old 10-22-2015
Without a decent (but maybe abbreviated) input sample (including file nomenclature) your spec is difficult to understand. Please post sth. to work upon.
# 3  
Old 10-22-2015
Hi there,

Actually it is fixed already.

Code:
echo "<table border = '1'>"
for file in *.html
do
    grep 'HostID     :' $file | awk -F '<br>' '{print $12}' | tr -s ' ' | awk -F ':' '{print "<tr><td>" $2 "</td><td>"}' 
    grep 'classsubsection\|./tcp\|./udp' $file | grep -v 'h2.classsubsection {\|Port\|0/' | sed 's/<[^>]*>//g' | grep -v '^$' | awk '{print $0"<br/>"}' 
    echo "</td></tr>"
done
echo "</table>"

However I am trying to iterate through the files with space.
10.244.9.124 nessus.html

Code:
grep: 10.244.9.124: No such file or directory
grep: nessus.html: No such file or directory

# 4  
Old 10-23-2015
Try double quoting the file name variable.

Constructing an organ (pipe next to pipe) might not be the best solution.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Extract table from an HTML file

I want to extract a table from an HTML file. the table starts with <table class="tableinfo" and ends with next closing table tag </table> how can I do this with awk/sed... ---------- Post updated at 04:34 PM ---------- Previous update was at 04:28 PM ---------- also I want to... (4 Replies)
Discussion started by: koutroul
4 Replies

2. UNIX for Dummies Questions & Answers

HTML: Display contents of file using Variable

<tr><td bgcolor=#D7EBAD><b>Instructions :</b></td> <td>`cat temp.txt`</td></tr> Hi Experts, I have an requirement of displaying file contents in HTML mail , for which am using the above approach, Where as the output is kind of not as expected. If there are 5 lines in the file, in the... (4 Replies)
Discussion started by: scott_cog
4 Replies

3. UNIX for Dummies Questions & Answers

Printing the contents of a file in a script with added chars

I have the contents of file1 1 2 3 4 5 6 7 8 9 i'm trying to figure out how to add chars to them so it would display as this, if it's possible 1 . 2 . 3 \ 4 . 5 . 6 \ 7 . 8 . 9 \ thanks! (1 Reply)
Discussion started by: austing5
1 Replies

4. Shell Programming and Scripting

Extract expressions between two strings in html file

Hello guys, I'm trying to extract all the expressions between the following tags: <b></b> from a HTML file. This is how it looks: big lines containing several dozens expressions (made of 1,2,3,4,6 or even 7 words) I would like to extract: <b>bla ble</b>bla ble</td><tr valign="top"><td... (3 Replies)
Discussion started by: bobylapointe
3 Replies

5. Shell Programming and Scripting

extract fields from a downloaded html file

I have around 100 html files and in each html file I have 5-6 such paragraphs of a company and I need to extract the Name of the company from either the one after "title" or "/company" and then the number of employees and finally the location . <div class="search_result"> <div... (1 Reply)
Discussion started by: gubbu
1 Replies

6. Shell Programming and Scripting

extract the contents from file to a new file

Hi i would like to extract some part of the file to a new file. first I would like to search for a string in the file and then i want two or three line above from the string to the the required string(can be any character) I would like this to be made generalized in a script Thanks (5 Replies)
Discussion started by: wedng.bell
5 Replies

7. Shell Programming and Scripting

Extract two file contents and consolidate in the third file

Hi all I have two files (first_file.txt) and ( second_file.txt). The first file consists of sentences line by line given as : Established in 1905 , Las Vegas officially became a city in 1911 . With the growth that followed , at the close of the century Las Vegas was the most populous... (10 Replies)
Discussion started by: my_Perl
10 Replies

8. UNIX for Dummies Questions & Answers

Printing File Contents Using AWK

I want to print the contents of a file from 2nd line to last but one line using the AWK command. I tried using the Shell Script,MyScript as fallows: MyScript: { if(NR>1) { if(NR<9) { print $0 } } } and used the commnd : awk -f MyScript Filename Note: Filename contains 9 lines text.... (0 Replies)
Discussion started by: ashok.g
0 Replies

9. Shell Programming and Scripting

Reading and printing one by one contents of a file

I have a file which has following contents: localhost_IP_SIP_1233026552455.xml localhost_IP_SIP_1233026552460.xml localhost_IP_SIP_1233026552467.xml localhost_IP_SIP_1233026552759.xml localhost_IP_SIP_1233026552969.xml localhost_IP_SIP_1233026552975.xml ... (2 Replies)
Discussion started by: Aditya.Gurgaon
2 Replies

10. 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
Login or Register to Ask a Question