.......Would it be possible to go ahead and have all of the fields in the output file?
Yes... However... is the rest of the data in the dup records the same for each dup? If not, that muddies the water a bit.
........The data is the first five characters in field2.
What about the order numbers with a letter and then 5 numbers? Do we want to excluse them?
Tom Gahagan
Alliance
Computer Solutions
"Music, like sex, is much too important to be left to professionals."
Robert Shaw