Regex and extract information from webpage (scraping)

Hi,
I am trying to scrape the ISIN Number from yahoo finance pages and need some help.

I have built the url that I need but can not figure out how to scrape this information. I have attached a text file (which essentially is the web page) and here is the link to the page.

http://uk.finance.yahoo.com/q?s=prty&m=L&d=
LVL 17
nepaluzAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
ErezMorCommented:
download the html page, then
use something like ReadAllText function to read the html page's source, then
use a InStr function to find "ISIN" - the value your after is just infront of this location in the text string,
and is ended by a closing paretheses - which you may easily find too

hope this makes sense to you, quite some work is yet to be done...good luck
0
 
smash_pantsCommented:
you could use xpath to access the text for the ISIN:

/html/body/div/div[2]/div[4]/div[3]/div/div/span

If you really need a regex for it then here you go:
^.*ISIN (.{12}) \).*$
0
 
nepaluzAuthor Commented:
ErezMor thanks for the contrib. I will give it a bash andsee what I come up with.

smash_pants (what a name!)I really am interested in the regex but can not get it to work. Heres the code I am using (and don't laugh!)


Dim fxk = Regex.Matches(sr.ReadToEnd.ToString, "^.*ISIN (.{12}) \).*$")

Open in new window

0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
nepaluzAuthor Commented:
OK - I have been un-able to implement either way suggested here, and though they may be correct, I am un-able to award poits for them. I am thus closing this thread and will try another one.
0
 
ErezMorCommented:
since the last post from user was "i'll give it a try and get back to you...", i dont think his closing reason is justified.
i happen to have some actual experience in doing just what i suggested the user, so in terms of if it works or not, there's no doubt here.
unless i didnt understand his question, or his closing request reason...

Erez.
0
 
nepaluzAuthor Commented:
OK then erez, I have been unable to use the instr as suggested (I think I have to repeat the obvious), could you post some code to this end?
0
 
smash_pantsCommented:
I've tested this code and it works.
Sorry i haven't been around much... I'm moving house.

string result = null;
string url = "http://uk.finance.yahoo.com/q?s=prty&m=L&d=";
WebResponse response = null;
StreamReader reader = null;

try {
    HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
    request.Method = "GET";
    response = request.GetResponse();
    reader = new StreamReader(response.GetResponseStream(), Encoding.UTF8);
    result = reader.ReadToEnd();
}
catch (Exception ex) {
    // handle error
    Console.WriteLine(ex.Message);
}
finally {
    if (reader != null)
        reader.Close();
    if (response != null)
        response.Close();
}
foreach (Match txt in Regex.Matches(result, @"^.*ISIN (.{12}) \).*$", RegexOptions.Multiline)) {
    Console.WriteLine(txt.Groups[1]);
}

Open in new window

0
 
smash_pantsCommented:
Here it is in VB.net

Dim result As String = Nothing
Dim url As String = "http://uk.finance.yahoo.com/q?s=prty&m=L&d="
Dim response As WebResponse = Nothing
Dim reader As StreamReader = Nothing

Try
	Dim request As HttpWebRequest = DirectCast(WebRequest.Create(url), HttpWebRequest)
	request.Method = "GET"
	response = request.GetResponse()
	reader = New StreamReader(response.GetResponseStream(), Encoding.UTF8)
	result = reader.ReadToEnd()
Catch ex As Exception
	' handle error
	Console.WriteLine(ex.Message)
Finally
	If reader IsNot Nothing Then
		reader.Close()
	End If
	If response IsNot Nothing Then
		response.Close()
	End If
End Try
For Each txt As Match In Regex.Matches(result, "^.*ISIN (.{12}) \).*$", RegexOptions.Multiline)
	Console.WriteLine(txt.Groups(1))
Next

Open in new window

0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
nepaluzAuthor Commented:
Thanks a lot and happy moving! If I may ask for a tweak, is it possible to have the regex NOT limiting the result string to 12 characters as you have it, but pich up to the closing bracket?

The ISIN (could?) be longer than 12 characters long and it would thus return an incomplete numer (or I am wrong?)

I have awarded the marks anyhow.
0
 
smash_pantsCommented:
in the regex:
^.*ISIN (.{12}) \).*$

just change the .{12} to what you need.

Capital letters an numbers at least 12 chars long:
[A-Z0-9]{12,}

any character ,any length:
.*


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.