I have a data set that is summarised to show permutations but I am only interested in combinations. Is there a quick way to alphabetically sort the characters within each string per row?
FIELD |
AAAA |
BAAA |
AABA |
ABBA |
BAAB |
BBBB |
ABAB |
ABAA |
Solved! Go to Solution.
I'm not sure there is a way to sort the characters with a single cell, but I did create a workflow that does that for you in a couple tools. First, add a RecordID tool then use the RegEx tool to tokenize your field to put each character on its own row. From here, you can sort the characters then concatenate them again.
Fantastic Kenda ... thanks!