28,404
社区成员
发帖
与我相关
我的任务
分享a="123,124,123,124"
ar = Split(a,",")
b = ""
For i=0 To UBound(ar)
If InStr(b, ar(i))=0 Then
If b="" Then
b = ar(i)
Else
b = b & "," & ar(i)
End If
End If
Next
ar = Split(b,",")
a="23,123,124,12,23,124"
ar = Split(a,",")
b = ","
For i=0 To UBound(ar)
If InStr(b, ","&ar(i)&",")=0 Then
b = b & ar(i) & ","
End If
Next
If b = "," Then
b=""
Else
b=mid(b,2,len(b)-2)
End If
ar = Split(b,",")