I have a file with data which need to select one or more records according to specific criteria (filters). Please, see below:
original file -
number of records - data
000001 jose silva dept purchasing manager position
000002 john coast dept maintenance supervisor position
.
.
.
.
003000 Paulo Santos purchasing dept coordinator position
I'm selecting records dept purchases. This is usually quite simple, but I need to maintain or generate a separate report indicating the number of the original record in the input file.
as below:
000001 jose silva dept purchasing manager position
003000 Paulo Santos purchasing dept coordinator position
and not so:
000001 jose silva dept purchasing manager position
000002 Paulo Santos purchasing dept coordinator position