How to parse out information in a text file

How can I read any file with the extension .zpl file extenstion and also how can i parse out data?
I need to parse the data out like the file attached.
Dim FILE_NAME As String = "C:\gftest.zpl"
        Dim data As String
        Dim objReader As New System.IO.StreamReader(FILE_NAME)

Open in new window

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brad HoweDevOps ManagerCommented:
What is the format of the gftest.zpl?

There are many ways to read in a file but you don't seem to have a writer yet.

Please provide example input and output and i'm sure someone will be able to assist.

cmdolcetAuthor Commented:
the format of the .zpl is a text file (.txt)
Here is how to read a text file

Dim TextInFile As String = IO.File.ReadAllText("C:\gftest.zpl")

What is the format of the data mate? Show us some sample zpl file.

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

cmdolcetAuthor Commented:
the data file is attached
What does this file contain? Is it some useful information? Did you try the above method?
cmdolcetAuthor Commented:
Yes i did try it. I need the file to be divided when ever you see a ^ so could i do a split? Right now everything is coming over in one variable I want to break it up and send data to other variables.
Yes you can use the split function

Dim FileContents As String = IO.File.ReadAllText("path")

For Each Portion As String in FileContents.Split("^")

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.