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.