AnsweredAssumed Answered

Sorting a field that contains a list

Question asked by ChrisSweet on Jul 6, 2015
Latest reply on Jul 7, 2015 by keywords

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

Attachments

Outcomes