shell script to parse html file

sais · #1 (**permalink**) 08-26-2009

hi all,

i have a html file something similar to this.

Code:

<tr class="evenrow">
<td class="data">added</td><td class="data">xyz@abc.com</td>
<td class="data">filename.sql</td><td class="modifications-data">08/25/2009 07:58:40</td><td class="data">Added TK prof script</td>
</tr>
<tr class="oddrow">
<td class="data">added</td><td class="data">xyz@abc.com</td><td class="modifications-data">filename2.sql</td><td class="modifications-data">08/25/2009 07:58:40</td><td class="data">Added TK prof script</td>
</tr>

and so till filname100.sql..
i need to fetch the "filename1-100.sql" ... the rest of the html can be ignored ... can anyone help me out with doing this.

vgersh99 · #2 (**permalink**) 08-26-2009

To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)

Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.

Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums

---------- Post updated at 11:10 AM ---------- Previous update was at 11:06 AM ----------

assuming all the 'files' you're interested in are '.sql' files:

Code:

nawk -F'[<>]' '{for(i=1;i<=NF;i++) if($i ~ /.sql$/) print $i}' myHTMLfile.html

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Parse for errors shell script	bubba112557	Shell Programming and Scripting	2	04-02-2009 12:25 PM
Help!!! Shell script to parse data file.	yajaykumar	Shell Programming and Scripting	3	09-24-2008 07:19 AM
Unix shell script to parse the contents of comma-separated file	KrishnaSaran	Shell Programming and Scripting	11	06-20-2008 06:43 AM
Parse a string in XML file using shell script	ayhanne	Shell Programming and Scripting	46	01-09-2008 12:33 PM
How to parse config variables from external file to shell script	pradsh	Shell Programming and Scripting	2	07-09-2007 03:21 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by