parse

Hi guys, I am a little stuck here. I am trying to read in a text file and parse it by line breaks however I cannot read the content of the parsed line breaks, it just shows up as 'Empty' when I watch them. Option Explicit Sub ParseText() Dim myFile As String, text As String, textline As...

I have a macro that reads through a text file pasted into a spreadsheet and extracts certain fields into another tab. The method I had been using was to actually split the text into two columns and set up data filters and filtered on certain fields and then copied that data to the other tab...

Hi everybody, I would like to parse a json string in VBA using this library : VB JSON Parser Library for VB6 (BSD Licensed) - Visual Basic, JSON here is an example of the json string I receive from a Web Service and want to parse: { "total": [[10000,1]], "periods": [1399852800000]...

I have a few hundred URLs that include campaign ID strings within them. I need a way to separate out the specific IDs from each URL. All of the campaign IDs are preceded by "?cid=" and they all follow a pattern of having seven sets of characters, each separated by a dash (e.g...

I have large number of sql files in various folders in my windows7 laptop. I have extracted the file names with full path in column A in an excel work book. For each row, I now need to parse the file and extract the file contents and put it in column B, for the respective row. I want the entire...

I regularly import CSV file data into an excel template. One of the columns in the template contains a material name. The material values are in the following format: "3/4 Int White Oak/Maple Mel" "3/4 Ext White Oak/Maple Mel" "Door/Drawer White Oak/Maple Mel" I want to reword them as...

Good evening, Following a suggestion on another thread, i've been using vba with ie document to parse javascript form results Dim IE As InternetExplorer Sub Update_Price() Application.ScreenUpdating = False Set IE = New InternetExplorer Set rng = ActiveCell...

Can someone be so kind to help me with building a macro for my issue I am trying to split address elements in separate columns some of the addresses have zip codes some do not some have country name some do not below is the format of the data that I have I would like to separate it into address...

Greetings,<o:p></o:p> <o:p> </o:p> I'm exporting data from a Rational database application into an Excel 2010 spreadsheet. I need to parse the data in a way that will group the data by object ID (XX-YY-25xx). <o:p></o:p> <o:p> </o:p> https://www.box.com/s/vgq2hk2bq24ik7jjck9w<o:p></o:p> <o:p>...

Hey, I have successfully parsed a few strings by following the very helpfuls posts in this forum. These one are all working well. My data looks a bit different than in the threads here so I would like some input from you if possible. I have imported the "JSON.bas", "cJSONScript.cls" and...

I'd like to refer to this post for a better understanding of what I'm trying to do http://www.mrexcel.com/forum/excel-questions/613012-visual-basic-applications-parsing-webpage-specific-value-between-tags.html I need help trying to extract specific values between tags from a list of websites...

I have an excel report with a lot of open but somewhat formatted text. I want to extract specific pieces. Below is the content (came out of a ticketing system). I want to parse out certain values. Ie. I would like the host=rbbserver, the Event ID: 4741 , and the Object= Balancer to all be...

I'm trying to figure out some approximate space requirements on a disc based on output from some Powershell scripts whose output data I have imported into Excel. The file structure is similar to this: z:\MyData\MyFolder\X1 z:\MyData\MyFolder\X2 z:\MyData\MyFolder\Images z:\MyData\YourFolder\A1...

I have an Excel sheet with lots of shortcuts in the first column. It's the entire shortcut, including the .lnk extension. What I need to do is to be able to parse out the string to make the shortcut human readable when I create the hyperlink. I'm saving the output as HTML for a user to open...

Greetings, I'm exporting data from a Rational database application into an Excel 2010 spreadsheet. I then create a pivot table to display the data as shown in the Data Source example (row 4) shown below. In cells D4 thru F4, I have a single row with multiple entries that are separately by what...

Hi I need to extract data from an excel file (using VBA) to another file. However, the data is stored in one cell with a line break to separate each item. I need to be able to read each string within the cell so that I can extract the mobile numbers (starting with 06 or 07). For the first...

Although I reference this forum alot I have never posted here before & I am a fairly rusty MACRO user I have an urgent need to take a workbook full of tabs about 70 so far (each tab represents the sales for a particular sales agent) I have to have a macro to export each tab to its own book in...

I have a webpage with an agravating amount of javascript within the HTML code. I can view the source and find the objectID=xxxxx.xxxxx.xxxxx.xxxxx value that i need to use. I want to use the value to open a final webpage directly. I am doing this to avoid opening several pages with sendkeys. I...

I have a webpage with an agravating amount of javascript within the HTML code. I can view the source and find the objectID=xxxxx.xxxxx.xxxxx.xxxxx value that i need to use. I want to use the value to open a final webpage directly. I am doing this to avoid opening several pages with sendkeys. I...

I have xls file, with many phonenumbers in column A. Can be different amount, so a loop is needed. <tbody> 08100100 08199999 08199919 </tbody> Those together with the string: http://personer.eniro.se/resultat/ will find a web page. Eg...