Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Is there a built in function for sorting characters in a string?

jackdaniels
8 - Asteroid

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
2 REPLIES 2
Kenda
16 - Nebula
16 - Nebula

@jackdaniels 

 

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.

 

Capture.PNG

jackdaniels
8 - Asteroid

@Kenda 

 

Thank you! This works and can be implemented further up the workflow.

Labels