3 Replies Latest reply on Feb 22, 2012 7:04 AM by Vincent_L

    how to sort "the second last digit"

    williamchandra

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