Sorting by character

Question

I have a sorting problem.

If I sort using the sort tool and descending order, I get

NameidABCD1234ABCD876

But, I needed my data to be sorted by character.

Output I need after sorting descending based on character:

NameidABCD876ABCD1234

Is there a way to do this?

Any help will be much appreciated.

CoG · Answer

@rjbrsh, Did you see @cjaneczko's Solution? It should do exactly what your looking for, where as @Hammad_Rashid's will perform a character based sorting, it will only sort on the first character. If you want all characters considered that will not work for you. I am attaching that workflow for you to look at, but please give credit to @cjaneczko, if his original response was the solution you were looking for.

Sample Workflow.yxmd

rjbrsh · Answer

@Hammad_Rashid  Thank you much, appreciate your help. This works for numbers but if the characters are alphanumeric, it doesn't work. Any way to fix that?

rjbrsh · Answer

Thank you much, appreciate your help. This works for numbers but if the characters are alphanumeric, it doesn't work. Any way to fix that?