parsing

  1. O

    MS Scripting for directory tree parsing

    Go easy on me. I'm more of a decent hacker using other's code not a programmer. 1st post here. Tried using recursive code I found based on MS scripting (which I barely understand) to parse directory tree to fill an array with all paths. It seems to be parsing fine as I can tell HOW MANY dirs it...
  2. G

    Deconding nested ASPX website data into Excel (plus a little javascript)

    I'm trying to pull some data from KY education websites (publicly available, starting at https://applications.education.ky.gov/SRC/Default.aspx). I've done programs before parsing website data, but at an HTML level; ASPX is a new beast for me, and so I'm in learning mode. What I'm wanting to...
  3. C

    Dynamic range that needs to be parsed, then reaggregated.

    I really would appreciate some extra eyes on this, I’m thoroughly stumped. Let me know if you have any questions or clarifications. I have a daily reconciliation with 4 unfortunately un linked data sources. Thus far I have created a macro that can handle 3/4 sources but I've hit a wall on the...
  4. S

    Thank you Chp Pearson - You were the Best. =StringConcat("|",IF(Sheet2!$E$7:$E$51=V41,Sheet2!$E$7:$E$51,"")) works. but how to get it to return & Joi

    =StringConcat("|",IF(Sheet2!$E$7:$E$51=V41,Sheet2!$E$7:$E$51,"")) Chip Pearson was the best. Thats his UDF - which I found (here: http://www.cpearson.com/excel/stringconcatenation.aspx/) - that he made to handle Concatenation properly, even the concatenation of arrays (Holy Grail!!!) My Only...
  5. B

    Determine if first character in string is greater than zero

    I have a dataset with numerous combinations of alpha and numeric values in a given column. I need to do TWO things. 1) Determine if the 1st character is numeric - if so, the initial condition is met. 2) If numeric, is the character between 1 and 9 (greater than 0) - if so, the final condition...
  6. H

    Innertext Help

    Hey all, I feel like my problem is a lot easier to solve than I think. I've checked Google/Youtube/etc, to no avail. I'm trying to pull innertext from a tag: <code> <td> ******** language="JavaScript" type="text/javascript"> //<![CDATA[ write_value("101",49862); //]]> *********>49862 </td>...
  7. I

    Extract cell references from a formula using VBA?

    First question, and I apologize if it has been asked before (I have searched the forums but did not find any posts that I recognized as a possible solution). If you're aware of another post that address this issue, please share the link! Context: I teach a college course, and my exams are...
  8. S

    Parsing Code Macro Trouble!

    I have raw code export: Cross Post: http://www.msofficeforums.com/excel-programming/31160-parsing-code-macro-trouble.html http://www.excelforum.com/showthread.php?t=1139253&p=4386328&highlight=#post4386328 And I want to parse it in to a table like this Its not finished but you get the...
  9. J

    Parsing User List

    Probably an easy one, but my brains are spent: Sheet 1 column contains "List of Users" names, last-name-first, with commas. Sheet 2 has column H: list of user's names (no commas), and N: "Usernames (log-in)". I'm trying to parse the Usernames from Sheet 2 into a new column in Sheet 1 for each...
  10. R

    Bit difficult to describe but to do with date/times from a log.

    Apologies for the vague title but I'm not sure how best to describe this challenge. I have a log from our GPS tracking system for all of our company trailers. I am trying to work out how long each trailer stayed on site at a particular destination for. The first complication is that for each...
  11. D

    Parsing strings from HTML code and writing to cells via VBA code

    Hi All, I'm new to this forum but found it very useful whenever I've had a problem with Excel or VBA. But get to the point. I'am currently working on a macro that will enable me to parse few strings from an online HTML source (ie. webpage) and write these values to an excel using VBA. So far...
  12. B

    Parsing a string and replacing characters using VLookUp

    Hello, I'm just trying to build a spreadsheet that will allow me to paste a column of text strings into column C that will parse the text and replace any non-alphanumeric characters with their octal codes (For example turn "(TM)" into "\236"). The symbols to replace will be in column A, the...
  13. D

    Macro to pars data

    I have a spreadsheet that contains names and addresses. What I need is a macro that will search each address in column F and if the address contains an apartment number (100 MAIN ST APT 123) I need to have the APT 123 stripped out and moved to Column G leaving 100 MAIN ST in column F. This must...
  14. W

    Convert Column of comma delimited Keyword/phrases to a range of unique values

    I have a column in a Table with keywords. Here's an example: <colgroup><col></colgroup><tbody> Location,performance errors,ip address,impact ip address, identification, transaction Performance, identification historic, performance, UI performance, consolidation, identification...
  15. 3

    Parsing baseball box score

    I am working on a project with baseball data from retrosheet.org. I want to create variables for the score of each team in each inning (VisInning1, HomeInning1, VisInning2, HomeInning2, etc). The problem is that the variable for the box score is coded strangely. Each team has its own variable...
  16. D

    VBA Parsing the webpage for a specific value between tags

    Hi all, I am trying to extract a specific value from a static webpage. so far I come up with the following script: Sub Macro1() my_url = "http://www.investopedia.com/search/default.aspx?q=rog" Set my_obj = CreateObject("MSXML2.XMLHTTP") my_obj.Open "GET", my_url, False my_obj.send my_var =...
  17. ejpuck

    Can I use a word or phrase as a delimiter?

    Hello All, I have a VERY long string of text copied from a web page. I'm only interested in certain relative data. Can the string be parsed or delimited such that I end up with three columns? One for The deceased's name, one for the executor, and one for the cause number? The text to columns...
  18. L

    Retrieving Info from an HTML site (source)

    Hello All, I am working on a statistics project that I could really use some help on. In short, I need to analyze data from a given website to draw the academic conclusions. The second caveat is that I'm extremely new (and extremely green) about using VBA so I'm not particularly familiar...
  19. J

    Importing and Parsing Email Text in Excel: interesting problem

    Thinking through a problem here and thought I would elicit thoughts from the board. I have a few thousand emails saved as text files. [For the sake of the problem, they are all saved in .txt format]. The issue is that the emails are often chains where the recepient/sender/dates/subject can...
  20. J

    How to Apply Range of Formulas to Each Row in 100 Worksheets

    I have 100 worksheets from a doctor's office. Each row is data from a patient visit. Each cell in a row contains string data about the patient (name, blood pressure, etc.) as well as the date of the exam, diagnositcs, etc. I want to create 100 new worksheets, but with some fairly basic...

Some videos you may like

This Week's Hot Topics

Top