Skip to main content
Question

sorting a string

  • December 4, 2018
  • 2 replies
  • 16 views

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

erik_jan
Contributor
Forum|alt.badge.img+22
  • Contributor
  • 2179 replies
  • 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
  • 14 replies
  • December 5, 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.

thanks that worked a treat!