Hi,
How can I sort the values within each cell in a column ?
So not sorting the column but sorting every value in each cell alphabetically ?
Thanks
Nikolaas
Hi,
How can I sort the values within each cell in a column ?
So not sorting the column but sorting every value in each cell alphabetically ?
Thanks
Nikolaas
Can you please provide an example?
Hi
Here is an example. So each value in colA is sorted alphabetically to form colA_sorted. So it is not a column sort but a sort inside each cell.
I expected that EasyMorph would have a sort() function that we could use in expressions with the option to choose the sort order (ascending, descending).
Yes that’s a good workaround. However it would be better if it is in a function
I have the same need…but in my case it’s a cell that has numbers separated by commas.
So for example a cell has value of 20,1, 12. How could I sort this to be 1,12,20? I tried the above solution, but it treats each character as something to be sorted…
You can use the “Split delimited values into rows” action, sort, and then concatenate back. Here is an example:
sort-inside-cell.morph (3.4 KB)
Ahh thanks @dgudkov - I forgot about the split delimited values into rows function. Your solution worked flawlessly as usual!
You’re welcome