AnsweredAssumed Answered

sorting alphanumeric fields

Question asked by MarlinPenner on May 20, 2011
Latest reply on May 20, 2011 by philmodjunk

Title

sorting alphanumeric fields

Post

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:

1,4-benzoquinone
Acetic hydrazide

when they should be sorted as:

Acetic hydrazide

1,4-benzoquinone

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).

Thank you

Outcomes