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
604 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

831 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