Hi all i have this application that loads html and it needs to search trough all the html and list the numbers between VALUE=" and "></td> .I mean i want to collect bold number :VALUE="3018"></td>.

My program what it does now it outputs like this with some extra things:

Code:
http://localhost/new/player.php?song=,"album.php?show_albums,"3018","3019","3020","3021"
but i want it to look like this this

Code:
http://localhost/new/player.php?song=3018,3019,3020,3021
i tried many things i could not remove the extra album.php?show_albums, and extra " from output url . I be happy if some one help me fix these problems.I bolded importent part.Thanks

Html code hast mane of this type of blocks
VB Code:
  1. <tr>
  2.     <td align="center" scope="row">1</td>
  3.     <td align="center"><INPUT TYPE="Checkbox" NAME="song_id" ONCLICK="reviewSelection();" [B]VALUE="[/B]3018[B]"></td>[/B]
  4.     <td><a href="#" class="song_title" onclick="loadPlayer('3018');return false;"> my life
  5. </a> </td>
  6.     <td align="center">&nbsp;</td>
  7.     <td align="center">&nbsp;</td>
  8.   </tr>


my code:

VB Code:
  1. Private Sub Command1_Click(Index As Integer)
  2.  
  3. Select Case Index
  4.     Case 0:
  5.         If txtURL.Text <> "" Then
  6.             RichTextBox1.Text = Inet1.OpenURL(txtURL.Text, icString)
  7.         End If
  8.    
  9.     Case 1:
  10.         End
  11. End Select
  12. End Sub
  13.  
  14.  
  15. Private Sub Command2_Click()
  16.  Dim sResult() As String, n As Long
  17.  
  18.               If GetLine(RichTextBox1.Text, "[COLOR=Red]VALUE=[/COLOR]", " [COLOR=Red]></td>[/COLOR] ", sResult) Then
  19.         ' Occurances were found and have been placed in the array
  20.      
  21.         Text1.Text = "http://localhost/new/player.php?song"
  22.  
  23.         For n = LBound(sResult) To UBound(sResult)
  24.           List1.AddItem sResult(n)
  25.           Text1.Text = Text1.Text & "[COLOR=Red],[/COLOR]" & Split(sResult(n), "=")(1)
  26.  
  27.         Next n
  28.        
  29.  
  30.                
  31.         '--------------- end of making url code
  32.        
  33.        
  34.     Else
  35.         ' No occurances were found
  36.     End If
  37. End Sub
  38.  
  39.  
  40.  
  41.  
  42. Private Function GetLine(ByVal sText As String, ByVal sStart As String, ByVal sEnd As String, ByRef sArr() As String) As Boolean
  43.     Dim lPos As Long, lEnd As Long, lCount As Long, sTemp() As String
  44.    
  45.     ReDim sTemp(100)
  46.    
  47.     lPos = InStr(1, sText, sStart, vbTextCompare)
  48.     Do While lPos
  49.         lEnd = InStr(lPos, sText, sEnd, vbTextCompare)
  50.         If lEnd Then
  51.         'Remove & sEnd from the below line.
  52.         'sTemp(lCount) = Mid$(sText, lPos, lEnd - lPos) & sEnd
  53.             sTemp(lCount) = Mid$(sText, lPos, lEnd - lPos)
  54.             lPos = InStr(lEnd, sText, sStart, vbTextCompare)
  55.         Else
  56.             sTemp(lCount) = Mid$(sText, lPos)
  57.             lPos = 0
  58.         End If
  59.         lCount = lCount + 1
  60.         If lCount > UBound(sTemp) Then ReDim Preserve sTemp(100 + lCount)
  61.     Loop
  62.  
  63.     If lCount > 0 Then
  64.         ReDim Preserve sTemp(lCount - 1)
  65.         sArr = sTemp
  66.     End If
  67.     GetLine = lCount
  68. End Function