9 Replies Latest reply: Nov 3, 2015 2:37 AM by Maarten Van Damme RSS

    Remove repeating values in a string (<> distinct values)

    Maarten Van Damme

      Hi,

       

      What would be the right way to remove directly repeating values in a string?

      e.g.

      Source string is "123444566556789"

      Target string should become "12345656789".

       

      So, it's not really finding the unique values, but rather avoiding the same number being repeated multiple times after one other.

       

      To give some background information: each number (1-9) represents a specific status, and I need to know the number of status changes.

       

      Thanks for your assistance!

       

      Kind regards,

      Maarten