Field and record delimited text file

[shootsnlad]

I have a file that I need to split into fields within records. I was hoping to split it into an single array for each record with the fields being each part of the array. The fields are separated with the pipe "|" system. The records are seperated by the "~" system. The field delimits aren't too bad, but I've never worked with a record delimiter. Any ideas on this? Thanks!

 

shootsnlad

[TheExtreme]

Read the file to a string

 

use the split function on "~" the get a RecordArray

 

loop through the RecordArray and split each element on the "|" symbol and get the FieldArray.

[shootsnlad]

How would I go about reading the whole file into a string? I know how to read a single line of the file into a string, but not the whole file. Would I use a StreamReader? I have the filename in a string but when I try to do the following, it doesn't recognize "file":

 

dim sr as system.io.streamreader
Sr = File.OpenText(filename)

 

Thanks...

[shootsnlad]

Nevermind, I got it.

 

It should be:

 

Sr = system.io.File.OpenText(filename)

 

Thanks!

[shootsnlad]

Now comes the tricky part. How do I split up an indivdual field based on a Carriage Return? What do I put inside of the quotes for the Split function?

 

shootsnlad

[goddesso]

Put vbCrLf inside your quotes to initialize it as the delimiter.