Removing Duplicates from a Member Filter
Hi All, I have the following use case whereby in my parameter, I have a member list of C#Local,C#USD,C#JPY,C#|WFText2| whereby WFText2 will be currencies/consolidation members eg. CNY,EUR,SGD,USD...
Forum Discussion
I am assuming that when you say 'member list' you mean a text string that contains a list of members rather than an object which is List(Of Member). You can use a hashset for that like this:
Dim input As String = "C#Local,C#USD,C#JPY,C#USD"
' Split the string by commas
Dim members() As String = input.Split(","c)
' Use a HashSet to filter unique members efficiently
Dim uniqueMembers As New HashSet(Of String)(members)
' Join back the unique members into a string
Dim result As String = String.Join(",", uniqueMembers)