Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

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 2 518
2 REPLIES 2
Top Labels in this Space