Skip to main content
  • EN

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.

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.

Reply


Community Stats

30,179
Posts
114,557
Replies
37,844
Members
Terms & ConditionsCookie settings
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.