Sorting

[Slobey]

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

[transpower]

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