Sort Alphanumeric

[deedeel]

Hi...I know there has to be a way...CR8.5

I'm using an Access XP database as the source...

I am trying to sort data by an alphanumeric string but it does so incorrectly...or at least not the way I want it

10A
14A
1A
2A

Want..
1A, 2A, 10A,14A

Access is giving me the same issues and when I tried to break it down my val and string there I coudn't pass the query onto Crystal.

Any easy ways around this??
Thanks - d

 

[MJRBIM]

Use the following formula to add a leading SPACE then sort ascending on the results of {@StandardLength}.

Name : {@StandardLength}
Formula : IF Length ({Table.Field}) < 3 THEN (&quot; &quot; + {Table.Field}) ELSE {Table.Field}

It will return your results like this...

Field StandardLength
- - - - - - - - - - - - - - - - -
1A 1A
2A 2A
10A 10A
14A 14A
- - - - - - - - - - - - - - - - -

 

[deedeel]

Thank you! That worked perfectly!!!