Shell Programming and Scripting

Hi All,

I'm trying to extract some floating point numbers from within some HTML code like this:

Code:

<TR><TD class='awrc'>Parse CPU to Parse Elapsd %:</TD><TD ALIGN='right' class='awrc'>            64.50</TD><TD class='awrc'>% Non-Parse CPU:</TD><TD ALIGN='right' class='awrc'>            99.42</TD></TR>

I've got the following sed but it strips out the spaces and decimal points - how can I modify this command so that I get a space (or any other delimiter) between each and maintain the decimal point?

sed 's/[^0-9]*//g' test.html

Many thanks,

p.

---------- Post updated at 04:49 PM ---------- Previous update was at 04:25 PM ----------

hmm, because these numbers appear more than once per line I'm thinking that sed isn't up to the job - will have a look for another method...

Try this:

Code:

sed '
s/[^0-9. ]*//g
s/ \+/ /g
' test.html

Thanks Deepak! Works a treat

I've not used multi-line sed before so messed about a bit and got this to work:

Code:

sed -e 's/[^0-9. ]*//g' -e  's/ \+/ /g' test.html