Skip to main content
Question

sorting a string


Forum|alt.badge.img

Hi, If I have records like this:

A,B

A,C

D,B

B,A

but I want the records sorted so

A,B

A,C

B,D

A,B

so I end up with duplciates is this possible the nearest thing I could find was "StringElementDuplicateRemover" but this removes string information?

cheers

2 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • December 4, 2018

Try this:

Use the AttributeSplitter (split on ,) to create a list.

Use the ListSorter to sort the list the way you want.

Use the ListConcatenator to create the sorted attribute (seperator ,).

And the you can use the DuplicateFilter to remove duplicates.

Hope this helps.


Forum|alt.badge.img
  • Author
  • December 5, 2018
erik_jan wrote:

Try this:

Use the AttributeSplitter (split on ,) to create a list.

Use the ListSorter to sort the list the way you want.

Use the ListConcatenator to create the sorted attribute (seperator ,).

And the you can use the DuplicateFilter to remove duplicates.

Hope this helps.

thanks that worked a treat!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings