Suppress records if first 5 characters are duplicated
Posted on 2004-11-25
I have a mailing list database that I was to suppress duplicates on if the first 5 characters of the ADDR field match the one in the previous (or any record!?) record ADDR field.
I can sort by ADDR easily enough, and 'Suppress if Duplicated', but it will not suppress the second entry if they are as follows
1 Alinda Road
1 Alinda Rd.
If I could just compare the first 5 or 6 characters of the field with a previous (or better yet, any record), and suppress (or highlight) then manual supression is a cinch.
Can ye help?