Left (yourfield; 3) will return the first three characters of your field
but how do you determine which of the two 002's should be kept ?
Thanks symbister. I did see that function but wasn't sure how to work it into my script. Going to give it a shot.
PS. To determine which of the same numbers to keep (as in this case, the 002's)…I just need to keep the first one.
You might define a calculation field with Left and use it to find your duplicates.
Thanks "sym" and "Phil".
I put "Insert Calculated Result" in my script then used the "Left" function. Works just like it should!