AnsweredAssumed Answered

how to sort "the second last digit"

Question asked by williamchandra on Feb 22, 2012
Latest reply on Feb 22, 2012 by Vincent_L

Title

how to sort "the second last digit"

Post

here is my problem

i only want to sort the second last digit from numbers

 

ex : 

Before sorting

1. 142905

2. 141084

3. 146715

4. 143751

 

After sorting

1. 142905

2. 146715

3. 143751

4. 141084

 

I can do it easily in EXCEL, but i have tried for months but still can not solve this problem in FileMaker.

Please help me.

Thanks in advanced..

Outcomes