New Bug Encountered: Sorting a SPLIT() list is not as expected

Consider the sample text string below:

 **`SomeText, 123.124, 1513.56.338, 6BT6613, SA 415+416'**

If I use the expression SORT(SPLIT([Sample Text], ",")) to sort ascending, the list order is:

 `6BT6613 , 123.124 , 1513.56.338 , SA415+416 , SomeText`

But, If I use the expression SORT(SPLIT([Sample Text], ","), true) to sort descending, the list order is:

 `SomeText , SA415+416 , 6BT6613 , 1513.56.338 , 123.124`

Note the placement of the value “6BT6613”

I know that when sorting non-homogenous data some unexpected things can happen. But in this case I can’t think of any reason why the sorting would be like this!!

3 Likes

Hi. In your first result, I don’t get the same sort. Wondering if this is database specific. Using your text of “SomeText, 123.124, 1513.56.338, 6BT6613, SA 415+416” (I removed the ** and also noticed your single quotes don’t match, one is curly :slight_smile: )

I get the following for both ASC and DESC. I am using google sheets, and I have marked my virtual fields as “element type text”:

Interesting! I went back to my tester app and basically re-synced, and now I show the order I expect. I did not change anything with those formulas. I did delete some other virtual columns that were not important but surely that wouldn’t have made a difference.

I’m using the same string input from my google sheet.

Could someone have already addressed this issue? Maybe as part of work unrelated to this bug?

No matter…it seems to be addressed now!!!

1 Like