7,763
社区成员
发帖
与我相关
我的任务
分享
Sub NewStr()
Dim Arr, k%, a$
Dim Dic As Object, Itm
a = "#13,#107,#90,#94,#17,#94,#106,#120,#20,#120,#99,#111,#23,#111,#114,#107,#13,#17,#20,#23"
Arr = Split(a, ",")
Set Dic = CreateObject("Scripting.Dictionary")
For k = 0 To UBound(Arr)
Dic(Arr(k)) = Dic(Arr(k)) + 1
Next
For Each Itm In Dic
If Dic(Itm) > 1 Then Dic.Remove (Itm)
Next
a = Join(Dic.keys, ","): Set Dic = Nothing
Debug.Print a
End Sub