Shell Programming and Scripting

Try this...

Code:

awk -F"<TD>" '{a=$NF;gsub(/[^0-9]/,"",a);if(a>50){gsub("<TR>","<TR style=something>")}}1' input_file

or

Code:

awk -F"<TD>" '{a=$NF;if(a+0>50){gsub("<TR>","<TR style=something>")}}1' input_file

--ahamed

Hi Ahamed, I am using AIX.

Hi balajesuri, I read your perl script code that seems it only match by pattern (if I read correctly, sorry I am new to perl script),
where I need the number comparison if ($no > 50), I only want to add <TR style...>, if less than 50 will not add "style" into <TR>. This is normally happen when admin person would like to highlight those > x%, the script will highlight those rows hit the threshold.

Similarly to Ahamed, the script is matching by pattern. it will be good if the script can cater for the above scenario.

Thanks for your afford.

---------- Post updated at 10:33 PM ---------- Previous update was at 09:20 PM ----------

Ahamed, thanks for your code. Is working now.

Thanks to balajesuri too.. I believe perl should able to perform the same task too. It will be good if you can send me the code as well. I am also keen on perl scripting.

Thanks all guys.

Sorry. My mistake. Try this regular expression to match any number strictly > 50:

Code:

/<TD>(5[1-9]|[6-9][0-9]|[1-9][0-9]{2,})<\/TD><\/TR>$/