I 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 RepliesI have a a few checkboxes that I want to be checked based on a value of columns in a table.So I have a table that has a date column and I run a search based on a particular date. Then I want to be able to go through the rest of the columns based on the selected date. But I need to be able to check individual values. Not sure if this is making sense. It is for a checklist. I want to click on a date, and it will auto populate checkboxes based on what was pulled from the db.
View 9 RepliesWhat I'm trying to do is parse a CSV file that has column headers, and map those headers - ideally to a class.The tricky part is that I need to be able to support various mappings because it will be interacting with different systems that give the headers different names. Additionally, being able to combine fields would be extremely helpful.
Fortunately, the CSV will always be correctly formatted with all fields encapsulated in double quotes.
[Code]...
I 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'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 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]...
This is my programs complete code, the only problem is i want to fix the amount of decimal places that show up in my gridview. The problem is if i do this on the asp side the location of the column gets thrown off and the column is duplicated. I figured if i just remade the table on the asp side it would work only problem is if i remove the sql for that particular column the asp side column cannot get data.
Imports System.Data.Sql
Imports System.Data.SqlClient
Imports System.Data
[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]....
I want to merge or import a column of data from one data table created in VB.NET to another data table's 'same-named' column.The destination data table has all the required columns created before hand but the source data table contains one column at a time, whose name is the same as that of one of the columns in destination data table.Whatever coding I have done for the same till now, results in blank rows at starting. The destination data table looks like this:And I want it to be displayed it as:
View 1 RepliesHow 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].....
SQL Server has a Data Type of "Float". Visual Studio has a Data Type of "Decimal". In other words, if I have a variable in a VB.Net app that is defined as a "Decimal" ...can I move that value into a SQL Server Data Table column defined as a "Float"?
View 4 RepliesI have a listview that has data in 4 different columns. It's just a quick phone storing project to keep "tuned up" on my programming.This is what i have to add the data into each column.[code]I need help finding the data in the second, third, and fourth column because that above is just returning the data in the first column.
View 2 RepliesHow to add a checkbox column at first column of datagridview including column header?After adding, how to code to "check all" or "uncheck all"?
View 27 Replies