AnsweredAssumed Answered

Numerical sorting in FM11

Question asked by jeffdpia on Apr 25, 2017
Latest reply on May 11, 2017 by jeffdpia

Pardon me if this has been answered already but I am having difficulties sorting files according to one field that we use quite regularly. The field contains numbers sometimes with a letter and hyphen prefix (like G-123).

If I try to sort the numbers 1, 10, 11 and 101 the sorted return is 1, 10, 101, 11. I'm a  new FM user on the create side but I am using someones old templates and dont want to make a global mess. Any help would be greatly appreciated,