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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.

791 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