How to read a delimetered line of strings and ints and extract them for processing in vb6

Question

0.00/5 (No votes)

See more:

Hi, 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

      Dim objReader As New System.IO.StreamReader(FILE_NAME)

      Do While objReader.Peek() <> -1
        TextLine = TextLine & objReader.ReadLine & vbNewLine

      Loop

      lblResults.Text = TextLine

    Else

      MsgBox("File Does Not Exist")

    End If

Any help is appreciated.

Posted 1-Jul-10 7:25am

btap_644

Add a Solution

3 solutions

Solution 1

You need to first split the string based on the blank spaces that you find within it and store them in an array. You will then need to check if each of the alphanumeric characters within this array are numeric or string.

Posted 1-Jul-10 7:28am

Abhinav S

Solution 2

I had the code all typed out and was ready to submit, and then I realized that you were after VB6 code, so I deleted it. Tough nuts to you, bucko.

Besides all that, this is a homework assigment...

Posted 1-Jul-10 7:46am

#realJSOP

Comments

btap_644 1-Jul-10 15:08pm

good guess. but i didnt ask u to do the coding for me perhaps a link to a sample would suffice like how william winner had given. Do appreciate you taking the time though, to answer.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

William Winner · Accepted Answer · 2010-07-01T08:09:00

Solution 3

So, you've figured out how to loop through and pull out each line.

When you pull out that line, you then need to search through each character and find the commas and get the text between them.

Or, you could just use the Split function (see here[^])

Posted 1-Jul-10 8:09am

William Winner

Comments

btap_644 1-Jul-10 15:07pm

Thanks winner looks alot like it