Solved

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

Posted on 2009-07-02
4
602 Views
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
0
Comment
Question by:nemesis1210
  • 2
4 Comments
 
LVL 8

Expert Comment

by:bhmahler
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.
0
 
LVL 2

Author Comment

by:nemesis1210
ID: 24766023
any chance you can point me to some sample code
0
 
LVL 85

Accepted Solution

by:
Mike Tomlinson earned 500 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

            sb.Append(Lines(i))
 

            ' Insert the Dashes

            sb.Insert(66, "-")

            sb.Insert(64, "-")
 

            ' put the changed line back in the array

            Lines(i) = sb.ToString

        Next
 

        System.IO.File.WriteAllLines(FileName, Lines)

Open in new window

0
 
LVL 2

Author Closing Comment

by:nemesis1210
ID: 31599290
Worked Perfectly thank you so much
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

914 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now