sorting alphanumeric fields
Hello, I'm a complete rookie so please provide a detailed response with few assumptions. My research group uses Filemaker Pro 9 to manage our chemical inventory. The chemicals are physically stored alphabetically but the names of chemicals are alphanumeric and when sorting chemicals by name the numbers are automatically considered first and then the letters. For example the following two chemicals are sorted as:
when they should be sorted as:
I was told that there is a way of sorting these as desired but have no idea how to do it. Also is there a way of doing this type of sorting also ignoring particular character combinations. For example (R) or (S).