I have this stored in Varible (History)
Date Open High Low Close/Last Volume
12:35 0.0004 0.0007 0.0004 0.0007 84,556,352*
01/21/2010 0.0005 0.0005 0.0004 0.0004 21,650,660
01/20/2010 0.0004 0.0005 0.0004 0.0005 8,030,977
01/19/2010 0.0005 0.0005 0.0004 0.0005 22,396,206
01/15/2010 0.0005 0.0005 0.0004 0.0005 15,749,998
How do I extract each line and store in Array (fhistory(6) ?
I want to reading in a excel file and extract the sCodenumber sDescription ans the sStatus and store them in a array : StatusComposeArray(5200) As MyCompose. After this I need this array for comparing outside this class. But as can you see the array is defined inside the sub: ReadingIn_ExcelFilesCompose [Code]
View 2 RepliesI am trying to create the following program Store in a 1d array a set of 5 place names and in a 2d array the distances between the places. Ensure that the order of the places is the same in both arrays. When the names are places are input the distance between them is displayed. If they are not both in the table a suitable message is displayed
Dim town(1 To 5) As String
Dim Dist(1 To 5, 1 To 5) As Integer
Dim First As Integer
[CODE]......................
I think the best way forward is pass a parameter to the function findnumber.
How to copy RichTextBox to an array line-by-line and back to another RTB From that array?
View 2 Replieswhat i need to do is open a txt file, read line by line, decode each line into an array and display. Now all works ok apart from one line.
sTextLine = objReader.ReadLine() <-- Value of string cannot be converted.
full code here
-------------
Dim objReader As New System.IO.StreamReader(sOpenFile.Text)
Dim sTextLine As New ArrayList()
Dim sText As String = ""
Dim i As Integer = 0
[code]....
I am new here and really excited to see the huge resources on this forum for vb.net. I have just started my learning of vb8 and need to create some basic applications for my personal use.I need to develop an application that can extract data from a html table and store that data into Access database. I have learned to create web browser on Visual Studio 2008. Below is the link from which I need to extract data and store into a database
View 3 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?
Suppose I already know the line number such as row 100 in a text file. How can I directly get it without many codes?
Code:
.....
99 Dim s1 as String
100 s1 = "Test"
101 MsgBox("Test Ok")
[Code]....
I dont know my programing language, how do i find out?[code]...
View 1 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.
My text file look like this[code]...
I want to extract those lines according to value in ( ).
i want to know what are the methods in order for me to extract the information that is stored in the exception. i also would like to know how do i extract the code line that caused the exception to occur.
View 6 RepliesI'm trying to read a file line by line into an array but It skips the item at index:3 I have it msgboxing just to make sure and it wont even touch it.
Dim Btn As Button = DirectCast(sender, Button)
Dim path As String = Application.StartupPath & "Libraries" & Btn.Text.Replace(" ", "_") & ".ipt"
Dim i As Integer = 0
Dim lines As String() = IO.File.ReadAllLines(path)
[code]....
i would like to store contents from a text file line by line to arrays before copying them to another text file. what i have is currently like this:
[Code]...
Currently I'm only able to store the whole content into one variable, would like to store the content line by line in arrays.
i have the following text file (ExamMarks.txt)
John, 85, 95, 90
Micheal, 60, 75, 75
I want to extract a line and take the Name and separately and the ints separately. Then I want to print the name and the average of the numbers like this in a label:
[Code]...
I have the following text file (ExamMarks.txt) John, 85, 95, 90 Micheal, 60, 75, 75
I want to extract a line and take the Name and separately and the ints separately. Then I want to print the name and the average of the numbers like this in a label: John's average is 90 Micheal's average is 70
So far I can only display what is in the text file in a label (see below):Dim FILE_NAME As String = "C:ExamMarks.txt"Dim TextLine As String If System.IO.File.Exists(FILE_NAME) = True Then
[Code]...
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]...
I have code that reads the whole file, not line by line.
Here is the code:
FileOpen(1, filename, OpenMode.Input)
Do While Not EOF(1)
datatodisplay = LineInput(1)
Loop
FileClose(1)
I would like to know how I can read the file line by line and then add all results into an array list.
i have a text file which contain 3 lines "ha 0.21, hb 0.35, hc 0.44" I want to read the file and get the second character of every line, which are "a, b and c" and assign them to array. My code below able to read the file but only able to get the last line of text. May i know how to do to get every second character and assign to array?
Dim FILE_NAME As String = "C:Test.txt"
Dim TextLine As String
If System.IO.File.Exists(FILE_NAME) = True Then
[Code]....
I must use streamreader to read text file line by line into array.
Here's what I've got.
Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
Dim numbers() As Double = New StreamReader(txtfile.Text)
Dim numbersarray() As Double
[Code].....
I 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 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 need to extract a value from a process array to myArray:
File: MyClass.vb
Public Function getTheRunningProcess()
Dim MyArray As Array
[Code]....
Now you might be thinking i can directly use the process in the File: Form1.vb but here is the situation, i have to use this function over and over again in different form as the application demands it has to be.
Okay here is a short video that shows exactly what I want to do. I'm a beginner with databases so I'm not that good at it. [url]...
View 12 RepliesDim strTest(recordSet.Count)() As String[code]...
Then once the array i populated above, i need to find the if another variable is contained in the second dimension of the second paren contains the value of my variable like this.[code]...
How can I store a specific line of text into a variable? Do I need some sort of array? For example:
1. My
2. Dog
3. Sat
4. On
5. Your
6. Bird
Let's say I only want line 4..Can I Copy an entire line of text just by searching a text file for a string, such as swf?**For example: I want to get a line of text saying http://mywebsite.com/myflash.swf, just by knowing the .swf extension.
This may take some explaining but the concept is pretty simple. A user will select a file which contains data that they wish to extract from, so keeping it simple they pick a file like so:
[Code]....
So, I need to show the user the file, allow them to select a line to match and/or extract from. So they select the first line ready for a match, they then select a word/s to mark as a constant for matching, so in this case it would be: MyGroup A simple version for text match would be like "MyGroup *" Now, I need to convert this to regex dynamically (I assume its the best method), its not a one off, the data that is selected is all open and up to user selection. There could be multiple selections and multiple extractions on the same line!
[Code]....
Row1
;W910 RF3500AA ;Increase volume by 40 db ;(c) summer ;(p) horse +1000000 F5 000000 5555 44 555555 904938291 8676859 00
Row2
;W910 RF350011 ;Increase backlight by 50% ;(c) winter ;(p) vistar +1000000 F5 000000 5555 44 555555 904938291 8676859 00
Row3
;W910 RF350022 ;Increase backlight by 100% ;(c) spring ;(p) spaceman +1000000 F5 000000 5555 44 555555 904938291 8676859 00
Row4 (Duplicate of Row3)
;W910 RF350022 ;Increase backlight by 100% ;(c) spring ;(p) spaceman +1000000 F5 000000 5555 44 555555 904938291 8676859 00
if label1 = RF350022
label2 = Increase
label3 = spring
label4 = 100%
only if it contains all of these words it should return the first instance (row3) then end or null the rest (row4).how can i get row 3 to show in message box now it has been found?
This illustrates a series of bytes that I've received from a socket and assigned into a byte array (frameData). How do I extract the ascii string from frameData if FrameData.Length is 79 bytes long and I need to extract the byte locations whose begin -frameData(26) and end frameData(44) are given by the arrows I've drawn?
View 3 RepliesI have been puzzling over this for about 2 days now but to no avail.All i am trying to do is retrieve all the "<a href = "myLink.php">MyLink</a>"
I can do it via the webbrowser with getElementsByTagName but i just cant for the life of me work out how i split the returned html into either an indexed array or just use inStr or Split function to split this into seperate value, But if i have a csv file with 20 links i dont want to have to load every page into a webbrowser control just to use getElementsByTagName.
Now it all works fine and retrieves the source code from the page. I have only extracted part of the code which is relevant to the retrieving html to try to shorten this post.
[Code]...