I have a large database with over 6 million records. Each record has only 7 fields, all numeric.
I would like to eliminate records that contain fields where the numbers are sequential in at least 4 fields.
Here's an example:
1,2,3,4,11,22,43 should be eliminated
1,22,23,24,25,37,132 should be eliminated
Can anyone think of an elegant method without manually searching and deleting?
Thanks!