Read a TXT file

[eduzs]

I have a txt file like that:

INCOME|
NAME|MARY
DATAX|100
DATAX|120
NAME|MARY
DATAY|100
DATAY|120
NAME|BILL
DATAX|180
DATAX|170

I need a code that reads this TXT file and return this txt file:

Name: Mary
DATAX 100
DATAX 120
DATA Y 100
DATA Y 120

Name: Bill
DATAX 180
DATAX 170

I know how to read/write text file, but get stuck in this do/loop if/then/else to list by name (no name repetition).

Any ideas? Thanks!

 

[ranman256]

sorry, i moved to a different thread.

use the DATA tab, from TEXT button.