Selecting records

[Hilton]

2 questions - Text File example:

Account,Status,Val
001,NB,0
001,PI,50
001,PI,100
001,CE,100
002,PE,500
002,PI,250
002,PU,0
002,PU,0
003,PE,100
003,CE,100
I would like to pick up ALL records of any account where there is NO CE
status and write it out to a separate file i.e.
002,PE,500
002,PI,250
002,PU,0
002,PU,0

I would like to pick up the LAST record of any account where PU = 0 i.e.
002,PU,0
and write it out to a separate file.

It is easy to do this using a database but a need has arisen to do it
upfront i.e before importing the data into the database and I thought a
simple VBA app will suffice. I know how to access the file, how to loop
through it and how to write out records to a new file but in this case there
is one or two aspects that I need some help with (eg how to "step back" to
pick up the other records once the required condition is met).

Hil

 

[Guest]

Hi,
Do not know about stepping back in the file once you
have started reading it. One way to solve your problem
could be to read the file and store it in a matrix,
account names with CE record in a separate vector and
account names with PU = 0 to a second vector. Then loop
through the matrix and select records based on your
criteria using the two vectors and direct output to
different files accordingly.

ojv