UNIX for Advanced & Expert Users

hi all,

I had raised the same question a few weeks back but forgot to mention a lot of points ... so i am raising a new thread furnishing my requirement ... sorry for that ....
here is my problem.
i have a html that look like below
<tr class="modifications-oddrow">
<td class="modifications-data">added</td><td class="modifications-data">abc@xyz.com</td><td class="modifications-data">/trunk/src/DELIVERIES/Framework/filename.sql</td><td class="modifications-data">25/08/2009 07:58:40</td><td class="modifications-data">comments1</td>
</tr>
<tr class="modifications-evenrow">
<td class="modifications-data">deleted</td><td class="modifications-data">sam@xyz.com</td><td class="modifications-data">/trunk/src/DELIVERIES/Framework/filename2.sql</td><td class="modifications-data">25/08/2009 07:58:40</td><td class="modifications-data">comments2</td>
</tr>
<tr class="modifications-oddrow">
<td class="modifications-data">modified</td><td class="modifications-data">robbin@xyz.com</td><td class="modifications-data">/trunk/src/DELIVERIES/Framework/filename3.sql</td><td class="modifications-data">25/08/2009 07:58:40</td><td class="modifications-data">comments3</td>

i need to get the names of the files ending with .sql, but only if the
<td class="modifications-data"> value is added or modified ...... if it is deleted then that value should not be displayed....

thanks and regards

try this command:

Code:

sed -ne '/<td class="modifications-data"> *modified/p' -e '/<td class="modifications-data"> *added/p' <<input_html_file>>|sed -e 's/.*>\([^<].*\.sql\) *<.*/\1/g'

Parsing with tools like awk, sed, shell might not be scalable or in other words that might not be the right tool to do the job.

Instead try with some CPAN modules that works with XML::Parser etc