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

    Sorting a field that contains a list


      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