Solved

read first line of each text file

Posted on 2011-02-23
11
288 Views
Last Modified: 2012-05-11
Hi experts,

I have different txt files (unknown file numbers), I would like to load them and read only the first line of each text file and then save them to a string.

The first line of each file is only a number such as:
test1.txt
1
2
3

Open in new window


test2.txt
3
2
1

Open in new window


test3.txt
4
5
6

Open in new window


So, I wanna load them and put all the first lines to one string like this:
mystring= "1,3,4"
note:
1 is the first line of test1.txt
3 is the first line of test2.txt
4 is the first line of test3.txt

Thanks in advance
Regards
0
Comment
Question by:Sat80
  • 5
  • 4
  • 2
11 Comments
 
LVL 53

Assisted Solution

by:Dhaest
Dhaest earned 150 total points
ID: 34959587
Try the following
string[] filePaths = System.IO.Directory.GetFiles(@"C:\test\", "*.txt");
            string output = "";
            foreach (string sFile in filePaths)
            {
                System.IO.StreamReader file = new System.IO.StreamReader(sFile);
                string strLine = file.ReadLine();
                output += strLine + " is the first line of " + sFile + Environment.NewLine;
                file.Close();
            }

Open in new window

0
 

Author Comment

by:Sat80
ID: 34959606
Thanks, I am sry that I didn't say I am using vb.net 2010.
I guess the code in different lang? C#?
0
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 350 total points
ID: 34959607
Try this:
        Dim list As New List(Of String)

        For Each filename As String In Directory.GetFiles("C:\test")
            Using sr As StreamReader = New StreamReader(filename)
                list.Add(sr.ReadLine())
            End Using
        Next

        Dim result As String = String.Join(",", list.ToArray())

Open in new window

0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Author Comment

by:Sat80
ID: 34959645
@carl_tawn, thanks.
For Each filename As String In Directory.GetFiles("C:\test")
Can I specify the ext?
For Each filename As String In Directory.GetFiles("C:\test\test*.txt") --> I got an error "Illegal characters in path"
0
 
LVL 53

Expert Comment

by:Dhaest
ID: 34959652
I'm sorry. I posted indeed in c#

For your last question: try:

For Each filename As String In Directory.GetFiles("C:\test\test, "*.txt")
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 34959668
What Dhaest said :)
0
 

Author Comment

by:Sat80
ID: 34959696
Thank you ALL :)
It's not working because the code miss "
For Each filename As String In Directory.GetFiles("C:\test\test, "*.txt")

And when I added " to the code
For Each filename As String In Directory.GetFiles("C:\test\test", "*.txt")

It then return the same error, strange!
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 34959705
What error?
0
 

Author Comment

by:Sat80
ID: 34959727
This one:
"Illegal characters in path"

I guess the line is wrong, coz I wanna load files not folder?

For Each filename As String In Directory.GetFiles("C:\test")

I want to load files starting like this:
c:\test\test*.txt

Because there are unknown files number on the test folder such as:
c:\test\test1.txt
c:\test\test2.txt
c:\test\test3.txt
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 34959747
If you want to restrict on name as well as extension then that needs to be part of your pattern:
For Each filename As String In Directory.GetFiles("C:\test", "test*.txt")

Open in new window

0
 

Author Comment

by:Sat80
ID: 34959761
Yes you are right, thanks you sir :)
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question