I'm trying to parse data from the web, basically, from an API rl...How do I approach this? Could I use XMLDocument to do this or MSXML2? [code]I've only worked where the node root doesn't have the name of the thing I need. So, how would I specifically retrieve the data for the node symbol? [code]
View 2 RepliesI have XML data like this:[code]I would like to return the name of the places. How may I extract this data using Visual Basic?
View 3 RepliesHow can I actually send a string or another variable on the run to another running .net app? I searched google and found nothing really,
View 3 RepliesI am trying to parse a file generated by LGA Tracon that lists the position data for aircraft over a given time frame. The data of interest starts with TRACKING DATA and ends with SST and there are thousands of entries per file. The system generating the file, Common ARTS, is very rigid in its formatting and we can expect the column spacing to be consistent. Here is an image to preserve the exact formatting Here is a reduced text file.
View 2 RepliesWe are using the following code to try to parse some text data from the URL below:
Dim strURL As String = "[URL]"
' *** Establish the request
Dim loHttp As HttpWebRequest = DirectCast(WebRequest.Create(strURL), HttpWebRequest)
' *** Set properties
loHttp.Timeout = 10000
' 10 secs
loHttp.UserAgent = "Code Sample Web Client"
[Code] .....
The problem is that the response we are getting in code is incomplete when compared with what actually renders in the browser. The html we are getting shows a javascript function in the body of html where what we really want is the result of the function, which includes the data we need to capture. This is confirmed by loading the page in Google Chrome, clicking on the text "100360" and choosing "inspect element" which allows us to see the full page response with the data we need, specifically the following line:
<pre class="pre-longText-wrap">100360</pre>
How to get this "raw" page response? It may be that the script is taking a few seconds to respond and that we are only seeing the initial page response.
I am trying to parse a webpage and need to get the data basically the string i am looking for in a webpage looks like thisSomeone lead me in the right direction in parsing the Stuff strings?
</b></a></td><td align="left" bgcolor="#F6F6F6">Stuff1</td></b></a></td><td align="left" bgcolor="#FFFFFF">Stuff2</td></b></a></td><td align="left" bgcolor="#F6F6F6">Stuff3</td></b></a></td><td align="left"
[Code].....
have to write a program/application (which I already started in VB.NET 2010) that connects through Panasonic KX-TEM824 PBX machine via RS232 port (cable already connected : COM15/16 depending on USB I connect) and while it's connected to parse(receive) the data from the PBX itself, data that has caller ID, time of call started and ended, duration of the call and etc. I have found some already application on the Internet that does the work but they are free to try after awhile requires to buy or restart the app again. But I assume there's not much to implement on the code side.
Imports System
Imports System.ComponentModel
Imports System.Threading [code]..
I'm trying to create a quick little program in VB 2008 that can parse extract the google search results based on the search criteria of the user input.
Basically what I have is a textbox1.text that enters the keywords into google, google will then put the url results back into my richtextbox1.text.
Here is the code that I have:
Private Sub WebBrowser1_DocumentCompleted(ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEventArgs) Handles WebBrowser1.DocumentCompleted
Me.Text = WebBrowser1.Url.AbsoluteUri
[Code].....
I'm writing a program that needs to parse data from a SQLite Database, I have the reference DLL but I do not know the proper syntax for the actual parsing of the file. The reference I have is located at [URL]..I don't really see any code that would need to be given seeing as the code for that class is currently something link:
Imports System.data.SQLite
public class SQLite
public sub Retrieve_Data
end sub
public sub Connect2SQLite
end sub
end class
In VB.NET 2005, what is the best way to retrieve and parse HTML data from a URL, a bit like a search engine crawler?I am building an app, where I need to parse a website, and collate data from it (the website uses some tags that I could pull out to get the appropriate bits of data). I want to be able to do this in a thread, and just update a DB with the data, and give the client app a status update of the progress.
View 6 RepliesI have a text reader and I wish to parse the readline string data in double.[code]...
I do not necessarily wish to define the split to interpret double space as separator as I do not know whether this is always the case. I would rather like to tell the program that there are three double format numbers -> go and parse.
is there a way to parse data from a command line tool such as netstat -b 2?
View 2 RepliesI have a string which contains html code from a webpage. There's a table in the code I'm interested in. I want to parse the numbers present in the table cells and put them in textboxes, each number in its own textbox. Here's the table:
<table class="tblSkills">
<tr>
<th class="th_first">Strength</th><td class="align_center">15</td>
<th>Passing</th><td class="align_center">17</td>
[code]....
As you can see there are 14 numbers. To make things worse numbers like 19 and 20 are replaced by images and numbers lower than 6 have a span class.
I have a List(Of Byte) that is filled with bytes from the serial buffer on a SerialPort.DataRecieved Event. I then try to parse the data. Part of the parsing process involves deleting elements of the List(Of Byte). Should I be concerned about the List being modified by a DataRecieved Event that might be raised during the parsing process? I realize that probably depends on what I'm trying to do, but, assuming I should be concerned (e.g., the parsing process needs List.Count to not change until parsing is finished), how should I go about making sure any Add calls wait until the parser is done? I guess the answer is something like SyncLock, but I've never really understood how SyncLock works.
View 1 RepliesI have an XML file that I need to parse to generate a few reports. What needs to be done is pretty simple, but I have no clue where to start with parsing the XML.The application will do this:Click a button to browse to an XML file where the format is static. Once the file is loaded, parse the file and generate a report using specific fields from the XML file. Criteria will be based on State(completed or incomplete), activity(Inspection, sample, etc). Here is 1 record of the XML file. Each consecutive record uses the exact same format.
<AsBuiltXML xmlns:lx="http://www.***.coml" version="1.0" date="10/20/2010" time="8:07:52 AM">
<Project name="S. 88th Street" desc="" />
<Units>
[code]....
I have some JSON data that looks like this[code]...
I get one root object with key "data", and value another object with 2 children, with keys "name" and "id", and the appropriate values one might expect. But when I try to cast that object to my UserData type, it returns Nothing. I had this code working at some point, but now that I am returning to it and attempting to use it again, it seems some code rot has set in and it has stopped working.
Everyone seems to have their own TCP dilemma so I figured I'd ask this here and see what the pros have to say. Basically I need to connect to an IP 192.168.5.100, port 8000 and listen for all the data that is being sent out. When I Telnet to 192.168.5.100 8000, it shows as...
[Code]...
I just want to parse simple expressions like IIF(FVAL(PFC) = TRUE, (IIF((ORGVAL(BAS, "2012/12/31") + ORGVAL(DA)) < 6500, (FVAL(BAS) + FVAL(DA)) * 12%, 780)), 0)`After parsing this I should be able to know what functions contains what parameters.
[Code]...
I'm stuck with .Net Framework 2.0, so no Linq or lambda expression goodies for me. Also I want to include the code in my custom library and not just reference it. Can anyone point me to some good library or code.
I just need to parse and not evaluate the expression and find what tokens are in use. After finding the tokens I need to change the expression string before parsing, like if the function ORGVAL is used then the parameter passed has has to be prefixed by an underscore. Like ORGVAL(BAS) will transform to ORGVAL(_BAS). Some functions can have tow parameters like ORGVAL(BAS, "2012/12/31") and this will transform to ORGVAL(_BAS, "2012/12/31")
NOTE: IF THERE ARE OTHER WAYS OF DOING IT PLEASE LET ME KNOW. I WOULD LOVE TO AVOID A PARSER AND LEXER.
Here is the code I am playing around My problem is parse data from html table can;t display in my listview It always display in first column only.
[Code]...
I have written code to pull some data into a data table and do some data re-formatting. I need some help splitting some text into appropriate columns.
CASE 1
I have data formated like this that I need to split into 2 columns.
[Code]...
column is the first 11 characters That is easy.column 2 should contain all the text after the first 11 characters up to but not including the first number.The last column is all the text after column 2
I'm having trouble with parsing an XML data from serial port.Actually I need to parse it automatically after all data is received from serial port.I can display all the data in a richtextbox control and all data is received perfectly but my problem isit seems that serialdata.eof function seems like it's not firing.
here's some of my code:
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'set serial port properties
With COMPort
.BaudRate = 19200
[code]....
what i need to know is how can i automatically parse the XML data from serial port after all data is received.
I need to load and parse a text file and extract data between points on any given line. I can load the file, but it's the parsing that's giving me headaches. e.g. "Phoned Jim and arranged for John to attend site" First I need to search for "Phoned" because the line always starts with that, and then I need to extract "Jim and arranged for John"
[Code]....
How can I parse a text file and extract the data to excel file. The text file is in the following format
CustomerInformation
Tim Alen
596 George Town
[Code].....
I'm still relatively new to parsing xml documents into SQL. I am trying to parse one node out of an xml document.[code]...
View 12 RepliesWhat's the easiest way in VB.NET to parse this XML? Here's an example of the full source:View Source XML I believe that the XML can be read directly into a class structure that matches the XML's structure.Let's take a bit of the XML from the above example,
<?xml version="1.0" encoding="UTF-8" ?>
- <kml xmlns="http://earth.google.com/kml/2.0">
- <Response>
[code]....
How do I handle nested collections, for example, the Placemark collection in this example?
I have an app that the user selects information and it writes to an XML file. The user can increase and decrease the information in the XML file so it is dynamic. The other app reads the xml file and uses it to complete tasks. Since the XML is dynamic my code needs to account for that. Right now I have only allowed the XML to have up to four values in a certain node, I would like to allow more but I will need to increase the Select Case function.[code]
View 8 RepliesI am making a change to an existing process. Currently the csv file (which can have embedded "," with the field in quotes), is being passed to my module as a IO.StreamReader, pStreamReader.
[Code]...
parsing text that i have loaded in to my textbox Using ofd1 As New OpenFileDialog ofd1.InitialDirectory = "F:"
If ofd1.ShowDialog = DialogResult.OK Then RichTextBox2.Text = My.Computer.FileSystem.ReadAllText(ofd1.FileName)
End If
End Using
create a function that parses the input "4+7-4/4*4=" from instr into an array named tokens(1000), as string, and returns the number of arrays, or perhaps a negative number if there is an error in the input.
Dim tokens(1000) As String
Private Sub btnGo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGo.Click
[code].....
I may be getting in way over my head, but here it goes. I am developing a small application for use on a helpdesk. The application will be installed on the client pc's and will be used primarily by the end user to assist the technician on the phone if the user's pc is offline or inaccessible. One part of the application gives the user their IP address, DNS address, DHCP address, and gateway address. I have it to where it will put all of those in the corresponding fields inside a form, but it does not work correctly outside of a domain. Outside of a domain it only gives the IP address. I am sure it is probably how I coded it, but I cannot think of any other way to get that info in a user friendly way. Is there a way to parse a command prompt command to specific fields inside of a form such as the command ipconfig /all?
View 3 Replies