VB.net code to Read all lines in Fixed Width text file and add characters in specific locations

Posted on 2009-07-02
Medium Priority
Last Modified: 2012-05-07
I am trying to code a small application which addresses a formatting issue in a text file received every month, its a fixed width file which has dates in a specific location such as 20090701 i need to change every line to read 2009-07-01 I was thinking maybe using streamreader or the like but cant quite figure this one out
Question by:nemesis1210
  • 2

Expert Comment

ID: 24765931
You can read all the lines of the file into a string array using System.IO.File.ReadAllLines("PATH TO FILE"), then you can jsut loop through the array and adjust the lines as needed and rewrite them to the file.

Author Comment

ID: 24766023
any chance you can point me to some sample code
LVL 86

Accepted Solution

Mike Tomlinson earned 2000 total points
ID: 24767045
Here's some example code:
        Dim FileName As String = "c:\some\file.txt"
        Dim Lines() As String = System.IO.File.ReadAllLines(FileName)
        Dim sb As New System.Text.StringBuilder
        For i As Integer = 0 To Lines.GetUpperBound(0)
            ' Pretend your date starts at Index 60.   (don't forget that indexes are ZERO based!)
            ' 20090701 --> 2009-07-01
            ' So we work BACKWARDS and insert at 66 and 64.
            ' Clear the StringBuilder and add the Current Line:
            sb.Length = 0
            ' Insert the Dashes
            sb.Insert(66, "-")
            sb.Insert(64, "-")
            ' put the changed line back in the array
            Lines(i) = sb.ToString
        System.IO.File.WriteAllLines(FileName, Lines)

Open in new window


Author Closing Comment

ID: 31599290
Worked Perfectly thank you so much

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…

607 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