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!!
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 )
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!!!
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |