Help

Sorting mixture of numbers and letters

Topic Labels: Sync
546 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Lever
7 - App Architect
7 - App Architect

How does AT sort (address) numbers that also have a suffix letter? For example, 2A, 2B, etc.

To overcome the sorting problem for addresses in a Filemaker desktop database I use, I have a separate field alongside the address number in which I enter the address number in numerical formal only and use that separate field for sorting. For example, 2.1, 2,2, etc.

tia

1 Reply 1
Michael_Lever
7 - App Architect
7 - App Architect

Answered my own question. AT sorts 2, 2B, 2A, 2C as 2, 2A, 2B, 2C.
so no need for separate field.