So I want to get the DOB of my account, but there are like 10 things that have "</td><td>", "</td></tr>" Is there any way to tell it like (5, "</td><td>", "</td></tr>") so it would get the fifth one?
So I want to get the DOB of my account, but there are like 10 things that have "</td><td>", "</td></tr>" Is there any way to tell it like (5, "</td><td>", "</td></tr>") so it would get the fifth one?
Think outside the box...
Grab a portion of the string that contains the birthdate, then do another getbetween grabbing the birthdate.
Code:Data = GetStringBetween(strHTML, "<b>Date of Birth</b><br>", "</td></tr>") Data = Replace(Data, "</td><td>", "")
(you need an account to see links)
(you need an account to see links)(you need an account to see links)
------------------------
[02/24/2013] Stealth CORE is made into the first standalone Neopets auto-player.
------------------------
jojo (03-21-2012)
Thank you so much!
Last edited by jojo; 03-21-2012 at 02:11 PM.
Is the most reliable way...Code:Public Function GetBirthday(strHTML As String) As String Dim startIndex As Long startIndex = InStr(1, strHTML, "<b>Date of Birth</b>") If startIndex = 0 Then GetBirthday = "Birthday not found" Else GetBirthday = Mid$(strHTML, startIndex + 35, 10) End If End Function
R (03-21-2012)ya n ~