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
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!