troubleshooting Question

Find the highest integer in a string using VB

Avatar of bs329
bs329Flag for United States of America asked on
Visual Basic ClassicScripting LanguagesVB Script
7 Comments1 Solution479 ViewsLast Modified:
I have the following string (as an example) and want to extract the highest integer only from the "High" column (the 3rd column) using vb:

<table width="100%" cellpadding="2" cellspacing="0" border="0"><tr class="yfnc_modtitle1" valign="top"><td><small><b>PRICES</b></small></td></tr></table><table border="0" cellpadding="0" cellspacing="0" height="2"><tr><td height="2"></td></tr></table><table class="yfnc_datamodoutline1" width="100%" cellpadding="0" cellspacing="0" border="0"><tr valign="top"><td><table border="0" cellpadding="3" cellspacing="1" width="100%"><tr><td class="yfnc_tablehead1" align="center" width="14%">Date</td><td class="yfnc_tablehead1" align="center" width="14%">Open</td><td class="yfnc_tablehead1" align="center" width="14%">High</td><td class="yfnc_tablehead1" align="center" width="14%">Low</td><td class="yfnc_tablehead1" align="center" width="14%">Close</td><td class="yfnc_tablehead1" align="center" width="14%">Avg Vol</td><td class="yfnc_tablehead1" align="center" width="14%">Adj Close*</td></tr><tr><td class="yfnc_tabledata1" nowrap align="right">Oct-09</td><td class="yfnc_tabledata1" align="right">0.51</td><td class="yfnc_tabledata1" align="right">0.76</td><td class="yfnc_tabledata1" align="right">0.48</td><td class="yfnc_tabledata1" align="right">0.59</td><td class="yfnc_tabledata1" align="right">1,970,200</td><td class="yfnc_tabledata1" align="right">0.59</td></tr><tr><td class="yfnc_tabledata1" nowrap align="right">Sep-09</td><td class="yfnc_tabledata1" align="right">0.56</td><td class="yfnc_tabledata1" align="right">0.67</td><td class="yfnc_tabledata1" align="right">0.48</td><td class="yfnc_tabledata1" align="right">0.50</td><td class="yfnc_tabledata1" align="right">873,300</td><td class="yfnc_tabledata1" align="right">0.50</td></tr><tr><td class="yfnc_tabledata1" nowrap align="right">Aug-09</td><td class="yfnc_tabledata1" align="right">0.37</td><td class="yfnc_tabledata1" align="right">0.93</td><td class="yfnc_tabledata1" align="right">0.35</td><td class="yfnc_tabledata1" align="right">0.56</td><td class="yfnc_tabledata1" align="right">1,080,100</td><td class="yfnc_tabledata1" align="right">0.56</td></tr><tr><td class="yfnc_tabledata1" nowrap align="right">Jul-09</td><td class="yfnc_tabledata1" align="right">0.32</td><td class="yfnc_tabledata1" align="right">0.39</td><td class="yfnc_tabledata1" align="right">0.26</td><td class="yfnc_tabledata1" align="right">0.34</td><td class="yfnc_tabledata1" align="right">186,700</td><td class="yfnc_tabledata1" align="right">0.34</td></tr><tr><
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros