+ Reply to Thread
Results 1 to 4 of 4

Guidance/Help parsing information from a webpage

  1. #1
    Registered User
    Join Date
    08-15-2013
    Location
    United States
    MS-Off Ver
    Excel for Mac 2011
    Posts
    2

    Guidance/Help parsing information from a webpage

    I am very green with Excel but I need to use it to cut time from daily tasks at work. Basically I am looking to parse the "SGID" tags from this site http://students.berkeley.edu/osl/stu...odo=listgroups and into excel so i don't have to copy and paste everything. Any and all help is very much appreciated.

    Michael

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Guidance/Help parsing information from a webpage

    What do you mean by parse in this case. Do you want to produce a list of SGID values e.g. 14575 or a list of hyperlinks or something else?
    Martin

  3. #3
    Registered User
    Join Date
    08-15-2013
    Location
    United States
    MS-Off Ver
    Excel for Mac 2011
    Posts
    2

    Re: Guidance/Help parsing information from a webpage

    Hey mrice,

    I would like to extract the names of the Clubs and Orgs that come after the SGID (not necessarily the #), and i suppose the hyperlinks would be nice too but mainly the names of the clubs. Is parsing not the right word to use??

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Guidance/Help parsing information from a webpage

    Try viewing the source in your web browser, copying all, paste special-text into Excel and sorting by column A. This seems to give a reasonably tidy list of names as hyperlinks - is this close to what you want?

+ 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. Replies: 2
    Last Post: 01-29-2013, 01:25 AM
  2. Inputting information into a webpage from VB Excel
    By saamer87 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2012, 08:46 AM
  3. Parsing address information using VBA
    By JasonCohn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-20-2011, 11:36 PM
  4. VBA and webpage information
    By detlion1643 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2009, 04:41 PM
  5. Parsing information
    By dj1cincy in forum Excel General
    Replies: 9
    Last Post: 05-23-2006, 12:10 PM

Tags for this Thread

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