I have address data that is surrounded by random text. Is there a way to extract this data either with a call to a web service or some vb.net function?
example: 1111 S WILSON ROAD APT B8 CITY STATE 55555 0 0 0 0 0 0 0
I am trying to extract some data from a website using a LINQ statement, the XML is in the following form.
<parent>
<p>
<b>
Title
</b>
[code]....
I would like to get the As Of Date and Data (the data row is iterated several times). Also the table and as of date appear several times in the document (the table is active from a date).I can get the rows using the following LINQ but how do I get the As Of Date
Dim l_PricesTable = From rows In l_Xml.Descendants("tr") _
Where ((rows.Descendants("td") IsNot Nothing) AndAlso (rows.Descendants("td").Count >= 1)) _
Select Data = rows.Descendants("td")(0).Value,
AsOfDate = ???
I have no way of changing the XML as it is a 3rd party source. There is no XML element which contains just the as of date and also the table, they are all under the one parent node.
i'm using two datetimepickers(from date and to date ) to extract records between these two dates.[code]
View 2 Repliesi have been searching the web for days and yet to find a clue on how to extract specific data from a flat file, i know how to extract all the data from flat file but not "specific data".
my problem now is that i need to extract a certain data out from a very very messy log file, what i need is to extract the decimal data right after "score=". it is in this format "score=1.938249".
for the decimal data right after "score", it is very random, there is no fix length to this. and also "score" does not fix in a specific position, it could be starting of the string or ending of the string of messy data.
just a peak on my messy data,
"time 20:34 17/1/2010 vlog=0 C:d7ad45f396850c532ef0ccf0da48d80di386peisgh437 ipint=98.1857991 score=1.78495 event@&1.13845"
"time 20:34 17/1/2010 vlog=1 C:Documents and SettingsDefault UserDesktop score=4.085651123 ipint=70.1578356 event@&0"
I've been looking over a bunch of code snippets and I'm just not understanding what is going on there.anding the connection, reading/manipulation, and closing pI keep reading all about these DataAdapters, Ole and Sql and Sqlce and I don't know which to use or whatever.I made a database in VB.NET 2010 that came out as database.sdf and I selected the Local Database option (I assume this is relevant?). I then populated the database with a row of data with column titles and a primary key. The table contains many different columns, but for test purposes, the following is relevant:
DB Name: db_test
Table Name: Locations
Primary Key Column Header: CITY
[code].....
I need to extract data from MS project 2003 .mpp file in dot net and dump in SQL Server.What is the best solution for this?1) I tried using OLE DB and fill dataset however it throws exception.
OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Project.OLEDB.11.0;Initial Catalog=D:TestProject.mpp;");
[code]....
This is my current output in a textfile that is created during the program. (Its different from my previous post)
!CH1 = S11,CH2 = S12,
-66.979,-60.518,
-61.403,-60.546,
[code]...
So, I wrote a loader that extracts an executable that I have stored as an embedded resource. It writes it to %TEMP%my.exe.I made my.exe extract some files on launch. Thats why I made it in the temp. But the problem is, when I do Shell(my.exe) to the temp dir in the loader, it runs ok. But the files execute to where my loader is. :S
I was expecting the files to be extracted WITH the my.exe in temp. So if ran on my Desktop, i'd get all these files, as with putting it in temp, it'd work a lot better.Any idea how to get my.exe to launch and not put files from my.exe to extract to the loader's launch dir?
I have this code to show percentage value of archive extraction. Now it shows 1-100% How do I make it have 2 more digits e.g 01.00-100.00% ? [code]
View 7 Replieshow do you extract multiple decimals with different number of decimal places from a string? I'm looking to find a generic way to extract 3 numbers out the following strings.
[Code]...
Scenario:I am attempting to perform some work on files (rename/delete) in folder, usually in a network location. Because the location of products folder is not critical, it's rarely ever in the same place on different networks. A simple shortcut on the client machine is all that's required from the client perspective and the rest of the product is self contained on the server somewhere. To run the 'fix' my small application will perform quickly and easily, I need to parse the path held in the target box of the .lnk. Then perform ifexists for a specific file and then do my renaming/deleting.
To keep it as simple as possible, the end user should just 'drop' the shortcut onto my form then click 'fix'.The problem: How in the heavens can I retrieve the target location from the .lnk into a string without windows scripting host?
Still getting to grips with regex and have seen a few samples about that give me most of what I need so asking for opinion on this. I need to extract x words from a single line, so the regex could use w+ to get characters, however my line may contain anything inside the word like:
[Code]...
How can I do once I click on the address bar it will erase what it says and write something else in that window?
View 5 RepliesHow am I able to send a data packet from my program, to an IP Address on a certain port (using Udp).
View 4 RepliesI need to make a program for my school (I`m the principal), that reads the text in the memory address of the program and write it down in a txt. I already have the address numbers. For more information, I use VS 2008.
I was trying to make one code to get the memory address. So, after I succeed this, I'll make the correct program.
The code I made(adapted from [URL] returning-0 ):
Public Class Form1
Private Declare Function ReadProcessMemory Lib "kernel32" (ByVal hProcess As Integer, ByVal lpBaseAddress As Integer, ByRef lpBuffer As Single, ByVal nSize As Integer, ByRef lpNumberOfBytesWritten As Integer) As Integer
[Code].....
I need to make a program for my school (I`m the principal), that reads the text in the memory address of the program and write it down in a txt. I couldn`t find a professional here in my city so, I already have the address numbers. For more information, I use VS 2008. I was trying to make one code to get the memory address, and after I succeed this, I'll make the correct program.
[Code]...
1. It only gets the first 4 bytes(is it?) of the memory address. I want it to get all of them.
2. I haven't discovered how to convert each byte(?) into a character. Is there a function for this?
3. When the program runs, after clicking ok on the MsgBox, it highlights the Next and debuggs:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Are there any IP Address filters or masks available in Windows Forms as per following screenshot? A backslash shouldn't be allowed or it should be filtered somehow.
View 1 RepliesSocketException was Unhandled: Only one usage of each socket address (protocol/network address/port) is normally permitted I get this error every time i click collect a second time.
[Code]...
Can anyone point me to some code which can help obtain the network address from the host IP and subnet mask?
View 3 RepliesIs it possible to use the streamWriter to read a .txt file thats in a web address online?
View 1 RepliesI have a database that has a text and a lot contain a free form of the person's address, city, state, and zip.
Incoming text would be:
John W Doe 1234 Big Lake Dr., Fort Worth, TX 76120 111-222-3333 jdoe@domain.net
Output of function should be:
1234 Big Lake Dr., Fort Worth, TX 76120
Here is some code I tried but doesn't seem to find anything:
Private Sub btnXMLTest_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnXMLTest.Click
lblOutput.Text = fnRegex("'John W Doe 1234 Big Lake Dr., Fort Worth, TX 76120 111-222-3333 jdoe@domain.net")
'other samples
[Code] .....
I have a web browser control in a form and id like to take the current web page address and place it in a text box is that possible ? Also it it possible to somehow bookmark web sites, sounds a bit vague i know. Am very new to VB and teaching
View 3 RepliesI want to make a program that looks like an address book (name, birth date, phone, e-mail etc) and stores all the persons data in a txt file. If I add a new person, for example, it will be added after the last person that was added in that txt file.
View 2 RepliesI am looking for the best way to capture and validate US & international personal data. I have to use ASP.NET 2.0 (vb.net) and no 3rd party web services. This are all client restrictions.
The main point of this is I have to toss their data to FedEx for a shipping quote. I think FedEx has a address checker but that web service was not approved in the scope of the project and its too late to get it added.
My current solution is to just let the field be required and free form then before I save their profile check to see if FedEx will return a quote. If it fails then I will ask them to recheck their profile or contact the admin.
it's simply connect to SQL and get name , mobile , last name , deaprtment , address data from table1 while id = 5?
View 10 RepliesI am developing a program that will manage students details. I have bound the program to an access database but i want the program to be able to retrieve a students first name and address when i enter the students first name in a text box and clicking a button.
I tried this code below but it didnt work.
Private Sub btnGetData_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetData.Click
dt = StudentDataSet.Tables("Mystudent")
[CODE]...
I made web browser which consist address bar that I use it to type addressess in it i.ewhen I type [URL] it opens [URL] but when I go to anther page in google it doesnot show it's link in address bar lix InterntExplorer or other international browsers so how to show any link or any sub page's link in my browser address bar ?
View 1 RepliesI'm trying to use the DHCP API (using the references on pinvoke.net) to retrieve a computer's MAC address when given the IP address but I can't get the code to work. I've run all the C# code on pinvoke.net through the C#-to-VB converter but I'm stuck now.
Here's what I have so far. The value of res is always 5 (should be 0). Thing is, I can't find any documentation on what the return codes mean
vb
Private Sub GetMACDim client As String = "1.1.1.1" Dim server As String = "0.0.0.0" Dim si As New NativeMethods.DHCP_SEARCH_INFO si.SearchType = NativeMethods.DHCP_SEARCH_INFO_TYPE.DhcpClientIpAddress si.ClientIpAddress = Convert.ToUInt32(StringIPAddressToUint32(client)) Dim res As UInteger Dim oInfo As IntPtr
[code]....
Using this
TxtBox = New TextBox()
With TxtBox
.Name = "T" & reader("area").ToString
.Visible = True
[code]....
The name would come out like "T3" Now I want to put a value into that textbox.How can I address the correct Textbox?
I have a form with about 48 checkboxes.I have a public sub that reads a webpage, parse the text of that site to get the values that correspond to these checkboxes.For example: one of the lines would be: "Exterior = 255", or "Street = 0".I do have check boxes that called "Exterior" and "Street". the question is how I can get my sub to address the appropriate control so I can set its "checked" property based on the text read.
View 3 Replies