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!!
User | Count |
---|---|
35 | |
9 | |
3 | |
3 | |
2 |