+ Reply to Thread
Results 1 to 7 of 7

What are the fastest and best URL text only extractors out there?

  1. #1
    Registered User
    Join Date
    09-02-2013
    Location
    US
    MS-Off Ver
    Excel 2002
    Posts
    25

    What are the fastest and best URL text only extractors out there?

    I have an excel spreadsheet that has to make a ton of web queries (around 9000 at the moment) and is using 2 websites to filter the result page to text only before searching for the data (if you are reading this, thanks again JasperD for your help)
    Those 2 text extractors are boilerpipe (http://boilerpipe-web.appspot.com/ex...ctImages=&url=) and google (http://www.google.com/gwt/x?noimg=1&u=).

    Boilerpipe is super fast in returning the result but the issue is that it has a low daily usage cap and stops working after only a short while. Google (as expected) is more robust and doesn't seem to have such a limit, but it's roughly 3 times slower to return a result, and when you compound that over 9000 queries, the difference becomes very substantial.

    Does anyone know better text extractors out there that will split out a text only version of a URL you give them, doing it fast (hopefully as fast/faster than boilerpipe) and do not have a daily usage limit? (or at least one that's way higher than my needs). If you do, please post away, the help would be much appreciated.

  2. #2
    Registered User
    Join Date
    09-02-2013
    Location
    US
    MS-Off Ver
    Excel 2002
    Posts
    25

    Re: What are the fastest and best URL text only extractors out there?

    Anyone knows?

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: What are the fastest and best URL text only extractors out there?

    What are you doing with the data once you've got it? Are you then extracting parts or are you just saving it all in a sheet?

  4. #4
    Registered User
    Join Date
    09-02-2013
    Location
    US
    MS-Off Ver
    Excel 2002
    Posts
    25

    Re: What are the fastest and best URL text only extractors out there?

    I'm extracting a part of it which shows how many results were returned by the URL query.

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: What are the fastest and best URL text only extractors out there?

    If you are only doing that, why can't you take it straight from the source of the page? Why do you need to use an intermediate HTML to Text type service?

  6. #6
    Registered User
    Join Date
    09-02-2013
    Location
    US
    MS-Off Ver
    Excel 2002
    Posts
    25

    Re: What are the fastest and best URL text only extractors out there?

    I'm not sure how I would go around doing that. I'm still quite a newbie at excel and programming.

    Here is the original thread with what I was trying to accomplish if you are interested:
    http://www.excelforum.com/excel-prog...ry-solved.html

    I have made a few modifications to the code that JasperD provided me. As it sits now, it has a full column of URLs, it checks each other sequentially with boilerpipe, if boiler pipe fails to result a result, it sends the query to google, then moves on to the next cell.

    Here is an example of a query which would return only the result 328 (at the time of me posting this, the result will vary with time):
    http://na.finalfantasyxiv.com/lodest...lang=ja&order=

    And here is an example which would return a result of 0 in my excel sheet (again, at the time of posting this):
    http://na.finalfantasyxiv.com/lodest...lang=fr&order=

  7. #7
    Registered User
    Join Date
    09-02-2013
    Location
    US
    MS-Off Ver
    Excel 2002
    Posts
    25

    Re: What are the fastest and best URL text only extractors out there?

    bump to find the best text extractors out there

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. importing text files into excel -fastest way
    By maran in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2014, 07:26 PM
  2. fastest way to find the row where a specific text is found in a specific column
    By getgray in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-23-2011, 02:45 PM
  3. Fastest Times
    By soss in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-13-2007, 02:09 PM
  4. Fastest Excel Machine
    By davidstone in forum Excel General
    Replies: 0
    Last Post: 08-26-2006, 10:11 PM
  5. Is this the fastest way to do it?
    By routeram in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2005, 05:47 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1