Get Flat File Data

[kleptos]

I have a text file

    1000|COL1|COL2|COL3|COL4|COL5|COL6|1
    1001|COL1|COL2|COL3|COL4|COL5|COL6|0
    1002|COL1|COL2|COL3|COL4|COL5|COL6|1

and i want to load ALL records and display COL1 in a ListBox (This i am able to do). Once i do that i want to be able to click on an element in the ListBox, go to that text file, get the other values (COL2, COL3, ETC) populate a few text boxes that all relate to that record (1000) in the textfile (Here is where i am lost). I also want to be able to update just that row (1000) with new data from the text boxes. For deleteing a row, i want to change the last character from a 1 (Active) to a 0 (Inactive).

Any help would be appreciated.