Hi,
I would like to find out a way to custom sort my summarized output.
Default sorting in output
Cancel | Sum_Count |
(Blank) | 6022 |
1 | 22 |
10 | 26 |
11a | 18 |
11b | 201 |
12a | 10 |
12b | 190 |
12c | 43 |
2 | 60 |
3 | 2 |
4 | 162 |
5 | 137 |
7 | 124 |
8 | 533 |
Desired sorting
Cancel | Sum_Count |
1 | 22 |
2 | 60 |
3 | 2 |
4 | 162 |
5 | 137 |
7 | 124 |
8 | 533 |
10 | 26 |
11a | 18 |
11b | 201 |
12a | 10 |
12b | 190 |
12c | 43 |
(Blank) | 6022 |
Thank you in advance!
Solved! Go to Solution.
Yes, the logic works but the size of the field is the issue. I did try with AutoField but it still didn't work.
I tried @MichalM tool but I don't know how to "use RegEx Parse to split the column into Numbers and Letters"...
The workflow is attached to my previous post. Here's the RegEx Expression
(\d+)([a-zA-Z]+)
Thanks! Sorry I missed the workflow which you attached in your earlier message. I will give this a try!
Thank you!