Forum Discussion
Solved
Need help with sorting alphanumeric values
Hello, I am trying to find a solution to how to sort alphanumeric values in a matrix visual. I have values :R1 R2 R3 R4 R5 R6 R7 R8 R9 R10. These values are coming from a New column (not calculated...
I guess i figured out a way to resolve the problem. By adding zero width space unichar() one can manage to tackle these kind of problem. Also adding space between the alphabet and number helps for numeric values in single digit, like R1 R10 R2 R3 will be sorted as R 1 R 2..... R 9 R10.
In case someone comes up with a more convincing solution please help!
I guess i figured out a way to resolve the problem. By adding zero width space unichar() one can manage to tackle these kind of problem. Also adding space between the alphabet and number helps for numeric values in single digit, like R1 R10 R2 R3 will be sorted as R 1 R 2..... R 9 R10.
In case someone comes up with a more convincing solution please help!