AnsweredAssumed Answered

Sorting alphanumeric strings

Question asked by Davisms on Feb 25, 2011
Latest reply on Mar 2, 2011 by philmodjunk


Sorting alphanumeric strings


We use Filemaker Pro in our libarary, and the call numbers always start with text and sometimes end with text.  The number of letters and numbers varies from one to four.   For example:

C 1001 A

C 1001 B

W MS 209

M 317

C MS 3

I've been successful at getting it to sort everything but the suffix.  I can get it to sort the suffix properly if all of the prefix letters are the same (i.e., C 1, C 1 A, C 17, C 29, etc.)

Is there a way to sort text-number-text?

Thanks for your ideas!