Hi everyone,

I have a question. Is there a limit to the number of characters used in a sort? I have a solution that has a field containing data from 3 different fields.

I have a script that uses this field to find duplicates. I sort them first and use a loop and a global field. If the global matches the field then is flags it as a duplicate. I have one item that doesn't flag as a duplicate and the only difference I can see is that it is the longest item I have. The field is as follows:

"J 0001463 Connector, Fargo-Bonding And Grounding. GC 164 Fargo, Connect Ribbon Or Braid To Ribbon, Braid, #6 Or Bus.WTR."

I tried using the trim function to eliminate all dashes and commas but that didn't work. Everytime I run the script is leaves 2 versions of this field and does not flag them as duplicates.

Please Help, it is driving me crazy.

Thanks

AFAIK, the limit is (nominally) the first 100 characters (as per FM Help).