Improve company productivity with a Business Account.Sign Up

x
?
Solved

Ho do I open each file in a folder and append the contents on separate lines in a new file?

Posted on 2008-09-30
2
Medium Priority
?
251 Views
Last Modified: 2012-05-05
I have several files in  a folder with one line in each of them. I want each lines put into one file appended after each other. Then I want to move the original file(s) to an archive folder. I am using VB.NET 2003. Do you have some code examples how to accomplish this? Thank you.
0
Comment
Question by:IT_Steve
2 Comments
 
LVL 86

Accepted Solution

by:
Mike Tomlinson earned 2000 total points
ID: 22610302
It might look something like...
Public Class Form1
 
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim sb As New System.Text.StringBuilder
        Dim outputFile As String = "c:\output.txt"
        Dim sourceFolder As String = "c:\data"
        Dim archiveFolder As String = "c:\archive"
        For Each file As System.IO.FileInfo In New System.IO.DirectoryInfo(sourceFolder).GetFiles("*.txt")
            sb.Append(ReadEntireFile(file.FullName))
            file.MoveTo(System.IO.Path.Combine(archiveFolder, file.Name))
        Next
        Dim sw As New System.IO.StreamWriter(outputFile)
        sw.Write(sb.ToString)
        sw.Close()
    End Sub
 
    Private Function ReadEntireFile(ByVal filename As String)
        Dim sr As New System.IO.StreamReader(filename)
        Dim entireFile As String = sr.ReadToEnd
        sr.Close()
        Return entireFile
    End Function
 
End Class

Open in new window

0
 

Author Closing Comment

by:IT_Steve
ID: 31501759
I wish I could make this stuff fluent for me like it seems for you. I guess I just keep at it. Seeing it makes it pretty clear.Thanks again for your assistance.
Steve
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

580 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