I know how to extract an entire page source into VB.NET, but once I do that how do I make VB.NET search the text and return a specific vlaue that is not constant? Take this line from the page source for example:
[Code]...
I know how to extract an entire page source into VB.NET, but once I do that how do I make VB.NET search the text and return a specific vlaue that is not constant?
Take this line from the page source for example:
<td id="actualPriceContent"><span id="actualPriceValue"><b class="priceLarge">$4.30</b></span>
the text is always constant but the price is not - how do I make VB.NET return the price?
I need to extract specific data from a database. With starting point in this data, I will collect information on the internet. After the information is collected I need to check if this information is already stored in the database, and if not, then add it. This action is being repeated about 500-50000 times each time the procedure is being executed. (not often)
The approach I'm taking seemes sleazy and ineffecient and I was hoping you could point out some places where I might be able to optimize it. I've two open connections at the same time. The first I use to extract data, and it stays open throughout the whole session. The second connection is being used first to check if an entry already exist and if not, to add the data.
The reason I am using two connections is due to the fact that I got a reader bound to the first one, so it is rendered unavailable.
I was thinking that maybe checking if the data existed, and adding it if not, maybe could be contracted into one command execution instead of two. I don't know if it would be possible to do this with one connection only as well, as it seemes more proper.
Imports System.Globalization
Imports System.IO
Public Class Form1
[Code]....
I have found the above code from the net and it works fine as I would expect. I know this because I have added a put the String StoreFile into a text box and it worked. From what I understand about the code above is that we are reading the file test.txt until we reach the end of the file and we are storing it into a string.
What I would like to do is either:
1. Search the String StoreFile until I find the text of my choice, and then extract the characters around it. See attached txt file.
For example, if I wanted to search for MNAUSD in the attached txt file, I want to grab the values on the line (highlighted in blue) and make them available to my program and ignore everything else.
"MNAUSD",UNITED STATES,US $,M,1.558850,1,1.369850,1.113500,L
I know these files are comma delimited, but I would rather use a regular expressions if possible as I have other files that are not comma delimited, so it would be ideal if I have a regular expressions to handle the search and extract
OR
2. Search the File test.txt LINE BY LINE, until I reach my search text MNAUSD and then extract the same values as above.
i have a log file which contains hundreds/thousands of seperate XML messages and need to find a way to extract a complete xml message depending on the parameters given (values of nodes).My biggest problem is that even though i program a fair amount i have had very little contact with XML or the XML libraries of the languages i use and didnt think that a simple text parsing would be an elegant solution!I am going to attempt this in C# or VB.net
View 3 RepliesI am trying to extract a number from a specific line and finding it an arduous task.
-#comments">18 comentarios</a></span>
I need the number before the word commentaries. This is a common phrase to search for and extract. the start of the line varies.
I am trying to extract a specific bit of text from a xml file. The file is located in C:Testspac emp1.xml and the specific text is between <space></space>How do I go about getting this text and displaying it in a textbox.
View 2 RepliesMy problem is to extract some specific string from the web script by RegExp, e.g:
1. <TD title="ABC - SDC">Home Furniture</TD>
- I want to extract "Home Furniture" from here.
2. <TD><INPUT class=ID="( 8352623 ) Demark" value="( 8352623 ) Demark"></TD></TR><!-- <tr> -->
- I want to extract "8352623" from here, can be any of them.
How can I write a RegExp to match them?
And I am getting one solution but work out in C#, obviously it's not working in VB, so anyone does me a favor to translate them in VB structure...
string pattern1 = @"<([tT][dD])[^>]*>(?<between>.*)(?=</1>)";
string test1 = @"<TD title=""ABC - SDC"">Home Furniture</TD>";
if (Regex.IsMatch(test1, pattern1))
[Code]....
My text file look like this[code]...
I want to extract those lines according to value in ( ).
There have probablly be thousands of threads just like mine[code]...
View 1 RepliesI have a Word document that has font sizes of 14 and 18, and the document is of 1500 pages.
I have to make specific changes to the font 14 and font 18, and so after searching, I came across VBA for Word that would allow me to do this easily.[code]...
how to parse and extract specific elements out of a JSON that I obtain from a web source. Using Visual Studio 2010 and VB. I can get the JSON but I haven't been able to find any examples or tutorials regarding parsing the data, locating specific elements and their associated data.
View 1 RepliesI got the following code from codeproject.com:
Dim objOL As Outlook.Application
Dim objNS As Outlook.NameSpace
Dim objFolder As Outlook.Folders
[Code].....
Now, I got as far as making the default folder the Inbox. What I would like to do is to extend the functionality by retrieving only a specific person's emails and extracting and saving whatever attachments he/she sends. Also, I get the following error when the code reaches the Dim Atmt as Outlook.Attachment part: Public member 'Attachment' on type 'Object' not found. I need this function to retrieve the attachments. I've tried different things, but nothing's worked.
I have a parse from Wikipedia saved in a text file in the following form: The town itself is situated to the south-east of the rock, and overlooks the Palaia Monemvasia bay. A small hamlet with about 10 houses lies to the northwest.The founding of the town and fortress of Monemvassia most probably occurred in the 6th century AD. The town was founded in 583 by people seeking refuge from the [[Slavic peoples|Slavic]] and the [[Eurasian Avars|Avaric]] invasion of Greece. From the 10th century AD, the town developed into an important trade and maritime centre. The fortress withstood the [[Arab]] and [[Normans|Norman]] invasions and conquests in 1147. Cornfields that fed up to 30 men were grown inside the fortress.What I need to do is to extract specific texts from the parse given the header names. For example, if I type in a textbot Geography I need ONLY the geography text returned.
View 8 RepliesDoes anyone knows how to export/extract/copy (or whatever is the right word) a file wich is added to the soulution, on the startup of a program, like somekind of installation?
View 5 RepliesThe info i need extracted is formatted:
<TD><A HREF="http://xxxxx.com/xxxxxx/index.html"><IMG SRC="../xxxxx/thumbnails/xxxxx.jpg"> </A></TD>
<TD>=== <B><A HREF="http://xxxxxxxxx.com/xxxxxxxx/index.html">LINE 0</A></B> ===<BR>
<FONT SIZE="2" COLOR="#400080">
[code]....
how do i extract the info between TD=== and /a and Line 1,2, and 3 and store it into a database from a live website?
I wonder if it is possible to find a specific row and specific columns in data base file (Access) . You see , I am using a DataGridView control to show only SOME of the columns (fields) of a table from an Access file . For example , lets say that in the DataGridView control I only show the following fields :Field1 , Field2 and Field3 .Now , when the user selects an entry in the DataGridView control , I want to insert the text from Field4 into a text box on the form .
The problem , however , is that I don't know how to get the specific row in the data base file and also I don't know how to get the text in column (field) Field4 of that row .One thing that might be important is that the index of the row in the data base file is not necessarily the same with the index of the current row in the DataGridView control . This is because in the DataGridView control the rows are order by the contents in the ID Field .ol .
I have an application that receives data input from an automated set of devices. This data stream I have managed to capture & get it into a list box which I can sort based on the Device ID & the time that the response was received.There is a set time window for the devices to transmit their data into the application and during this each device is not limited to the number of responses it can send (ie :- Device 1 can send in 2 responses where Device 3 can send in 40 responses, etc).All of the responses are captured, listed & sorted within the listbox (this bit is working ).I now need to extract the last (ie:- latest) entry in the listbox for each Device ID & this is where I am stuck. I can retrieve the last item in the list but cant seem to extract the last item for each Device ID.[code]
View 2 Repliesloop through a textbox control content and extract specific content from it
View 20 Repliesi want to make a program that can extract only text from html code.
so far i have done this:
dim br as new browser
br.Navigate(url.Text)
While Not br.ReadyState = WebBrowserReadyState.Complete
[Code].....
this code generate whole html source code including text and everything. iwant only text shown in webpage.
i have a question is it possible to make a program that can self extract it self? EG. i have app1 and i run it and other 2 files are produced.and another program that does the opposite: i have app2 and other files and packs it self into 1 .exe file
View 8 RepliesI need to extract the whole string if the string has today's date on it. I have already coded a string that displays today's date in the following format - yyyy/MM/dd And I've coded the parsing links bit, now I need to simply search the Listbox and return the first string with the date. [Code]
View 11 Repliesi'm trying to make a program that searches for a specific file in a specific file, so when the program loads it "writes" in checked list box the names of the drives installed to the computer, but what i want to do is: when the user checks the box, i want it to search for the file in that drive, but i don't know how to do it...
I'm using:
Imports System.IO
Imports System.Collections.ObjectModel
Public Class Form1
[Code].....
how to make it search in the other drives using the checked listbox?
This XML file is CONSTANTLY updated every 3 seconds..
[code]...
If value of each field exceed a certain reading, do (sendsms)I've that sensms function already..
I am still learning the ropes of vb.net. Most of the time I get by fine, using google and searching here. But i've run into a road block. I am trying to extract email adresses from the source code of my website, suppose I can populate the Rich text box with all the source code, and the are emails sitting inside. How would I extract the emails from it and put them in a separate box.[code]...
View 1 RepliesI want to make a extractor/installer for example the users will press Install and it will extract myprogram.exe at C:/windows/system32/ automatically when they press install.
View 7 RepliesI have an array DetailsArray in VB.NET which contains the result of a LINQ query. I have shown below the values of the array. i need to get the "ProjectID" from the array and assign it to 'ProjID' variable
DetailsArray (0){Name =
"TestProject1", ProjectID = 10}
Dim ProjID as Integer = DetailsArray(??)
How would I do that?
I would like to extract data from a html tag. The html tag is included inside a big html document.
Precisely i would like to extract the value of "txtGUID" from this html tag :
<td width='75%' bgcolor='#F3F3F3'><input type='hidden' name='txtGUID' value='soft:24f709f1-becb-44c6-8359-7c8b0b4a6e14:SLIP'/></td>
I have the following code to open a webpage:
Dim IE As Object
Dim x As Integer
Dim c As Variant
[code]....
The page that opens is in xml and in that xml there is the "page_count" that I need to pick out so I can tell my macro when to stop looping. I have dimmed it as "c" in the code above. Following is the XML.
<search>
<total_items>360</total_items>
<page_size>100</page_size>
<page_count>4</page_count>
Somehow I need c = "4", which is the "page_count". Does anyone know how I can pick out the "4" from the xml on my page?
I have to do my project in computing which requires extract data from excel to VB for further processes. I am a beginner. I know a little bit about VB and Pascal.
View 2 Replies