3 Replies Latest reply on Jul 7, 2015 1:24 AM by keywords

    Sorting a field that contains a list

    ChrisSweet

      Can anyone help please.

      I have a table with a field called Links. This field contains several ID numbers all separated by a carriage return.

      If I sort the table on the Links field it doesn't seem to be giving me the right sequence.

      I've attached a screenshot of part of the table when exported to Excel. Row 18 should appear between rows 11 and 12 but it looks like the sort isn't working. I put zeroes at the end of every field just to eliminate (prove) there were no hidden characters.

       

      If I sort the Excel file on Column D 'Links" I get the right result..

       

      Many thanks in advance

      Chris