Yes it is possible. In fact let Internet Explorer do the dirty work for you. MY ASSUMPTIONS I am assuming that the html text is in Cell A1 of Sheet1. You can also use a variable instead. If you have a column full of html values, then simply put the below code in a loop … Read more
class LinksParser(HTMLParser.HTMLParser): def __init__(self): HTMLParser.HTMLParser.__init__(self) self.recording = 0 self.data = [] def handle_starttag(self, tag, attributes): if tag != ‘div’: return if self.recording: self.recording += 1 return for name, value in attributes: if name == ‘id’ and value == ‘remository’: break else: return self.recording = 1 def handle_endtag(self, tag): if tag == ‘div’ and self.recording: self.recording … Read more
Tokenizing can be composed of a few steps, for example, if you have this html code: <html> <head> <title>My HTML Page</title> </head> <body> <p style=”special”> This paragraph has special style </p> <p> This paragraph is not special </p> </body> </html> the tokenizer may convert that string to a flat list of significant tokens, discarding whitespaces … Read more
Use File.ReadAllText passing file location as an argument. However, if your real goal is to parse html then I would recommend using Html Agility Pack.
Parsing usually applies to text – the act of reading text and converting it into a more useful in-memory format, “understanding” what it means to some extent. So for example, an XML parser will take the sequence of characters (or bytes) and convert them into elements, attributes etc. In some cases (particularly compilers) there’s a … Read more
http://hackage.haskell.org/package/shpider Shpider is a web automation library for Haskell. It allows you to quickly write crawlers, and for simple cases ( like following links ) even without reading the page source. It has useful features such as turning relative links from a page into absolute links, options to authorize transactions only on a given domain, … Read more
Native XML Extensions I prefer using one of the native XML extensions since they come bundled with PHP, are usually faster than all the 3rd party libs and give me all the control I need over the markup. DOM The DOM extension allows you to operate on XML documents through the DOM API with PHP … Read more
You need to put the pattern in parentheses /([A-Z])/, like this: preg_replace(“/([A-Z])/”, “<span class=\”initial\”>$1</span>”, $str)
How about something like: Using HTML Agility Pack HtmlDocument doc = new HtmlDocument(); doc.LoadHtml(@”<html><body><p><table id=””foo””><tr><th>hello</th></tr><tr><td>world</td></tr></table></body></html>”); foreach (HtmlNode table in doc.DocumentNode.SelectNodes(“//table”)) { Console.WriteLine(“Found: ” + table.Id); foreach (HtmlNode row in table.SelectNodes(“tr”)) { Console.WriteLine(“row”); foreach (HtmlNode cell in row.SelectNodes(“th|td”)) { Console.WriteLine(“cell: ” + cell.InnerText); } } } Note that you can make it prettier with LINQ-to-Objects if … Read more
Pyquery provides the jQuery selector interface to Python (using lxml under the hood). http://pypi.python.org/pypi/pyquery It’s really awesome, I don’t use anything else anymore.