Skip to main content
Question

How can I alphabetize a text string?

  • April 15, 2021
  • 1 reply
  • 50 views
R

I need to check a match between two output fields. The order of the data is inconsistent, and therefore ABC is not flagging as a match with CBA. I want to alphabetize the text strings so that the order is consistent and can be picked up via the equals or contains function in TestFilter.

1 reply

caracadrian
Contributor
Forum|alt.badge.img+23
  • caracadrianContributor
  • Contributor
  • April 15, 2021

Sort the characters.

Use StringSearcher with the RegularExpression (.{1,1}) and set a name for the Subexpression Matches List. Use a ListSorter on thatlist{}.part followed by a ListConcatenator on thatlist{}.part and a blank Separator Character.

 

I have attached a demo workspace that does that for you.

Community Stats

32,687
Posts
124,042
Replies
41,139
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.