Deleting Duplicates.. another twist
There have been some posts that come close to answering this but I still need a little guidance.
I have a database that has a File No. field and would like to delete duplicates based on the first 3 characters of the field.
For example: Here are the numbers in the field (the brackets indicate what I want as an end result)
...and so on
I use a script I got from another post that almost works, but it keeps all the 001's because it sees the letters as a different number. If I have FMP check only the first 3 characters it may work.