Hi - We have a file that is received from a vendor ( item_nbr 10 byes and location 20 bytes) . File is a 80 byte FB record
item_nbr location 4046340¦CORPORATIVO 4046564¦CORPORATIVO 4046564¦ESTADO 4047131¦CORPORATIVO 4047460¦CORPORATIVO 4047479¦CORPORATIVO Here we need to extract item_nbrs that has only "CORPORATIVO" location and no other location defined . In the example above it should pull 4046340¦CORPORATIVO 4047131¦CORPORATIVO in the output file. If we look 4046564, that is defined for CORPORATIVO and ESTADO so that should not be picked in the o/p file. Could anyone please let me know how to do in DFSORT job Thanks Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN