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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
How to trouble shoot .net contact form 3 31
Merging PDFs with VB.NET 10 32
Round up to 100% in .NET 10 46
Format column on datatable 7 18
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 …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

744 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

12 Experts available now in Live!

Get 1:1 Help Now