VB 2010 text file to listbox

botes82 · September 3rd, 2012, 07:51 AM

hi, i want to open a text file into a listbox, this i have managed. however i need to take out the first line of the text file and put that into a label once i have opened the text file. any help please

Ian Ryder · September 3rd, 2012, 09:19 AM

Hi,

Please can you post the first few lines of your file so that I can see what you are trying to achieve. - (You cannot load files in this forum so please wrap the first few lines of the file in quote tags to keep the formatting) - In essence, this should be easily achievable by searching for the first Carriage Return, which then gets placed in the label and then the rest goes in the Listbox.

Cheers

Ian.

botes82 · September 3rd, 2012, 09:24 AM

VB10
01/06/2010,140
02/06/2010,255
03/06/2010,252
04/06/2010,314
07/06/2010,28
08/06/2010,309
09/06/2010,69
10/06/2010,222
11/06/2010,81
14/06/2010,236
15/06/2010,171
16/06/2010,217
17/06/2010,285
18/06/2010,82
21/06/2010,203

That is some of the text file... the "VB10" is what i want to extract and make that the label.

Ian Ryder · September 3rd, 2012, 10:19 AM

Hi,

Here is an example of how you can achieve what you are trying to do:-

1) Add a Label and a Listbox to a form.
2) Copy the code below to the form load event ensuring you replace the test.txt filename with your own file location and name.

Code:

    
'read the file
    Dim fileContents As String
    fileContents = My.Computer.FileSystem.ReadAllText("d:\temp\test.txt")
    'strip out the first line of the file using indexof to find the first CR/LF and then apply to the label
    Label1.Text = fileContents.Substring(0, fileContents.IndexOf(vbCrLf))
    'strip out the first line of the file, compensating for the space needed for CR/LF and then apply to the listbox
    fileContents = fileContents.Substring(fileContents.IndexOf(vbCrLf) + vbCrLf.Length, fileContents.Length - fileContents.IndexOf(vbCrLf) - vbCrLf.Length)
    ListBox1.Items.Add(fileContents)

I notice that the subsequent lines in the file have multiple fields? So a question would be:- Is a list box the right control for what you want to do depending on what you are trying to show?

Hope this helps.

Kind regards,

Ian