Editing file data.

[ltfcphil]

Hi,
Bit of a noobie question I'm afraid....

I have a program to open a file,read out part of each record to a text box, make a selection then extract the entire record. This works OK.

Now I require to edit and replace the record. (Each field in the file uses commas as delimiters.)

Attempting to replace a record either appends the file or overwrites the whole lot, so that I get a file with just my edited record in it.

Can anyone suggest a way to do it correctly?

If possible I would like to use a similar method of writing as reading.
The method I am using to read is:

Dim x As Integer = 0
Dim AClass As String
Dim currentRow As String()
Dim rowlen As Integer

Using Myreader As New _
Microsoft.VisualBasic.FileIO.TextFieldParser("SBDa ta_Class.dat")
Myreader.TextFieldType = FileIO.FieldType.Delimited
Myreader.SetDelimiters(",")

While Not Myreader.EndOfData
'pull out records and write to textbox

Try
currentRow = Myreader.ReadFields
rowlen = currentRow.Length

For x = 0 To rowlen - 1
AClass = currentRow(x)
ListBox3.Items.Add(AClass)
Next

Catch ex As Microsoft.VisualBasic.FileIO.MalformedLineExceptio n
MsgBox("Line " & ex.Message & _
"is not valid and will be skipped.")
End Try
End While
End Using

End Sub

Any help greatly appreciated,
Phil