7,785
社区成员




陈永娥 13325357396
卢欢 郑盈
已确定__李王琴 1__李王琴
已确定__陈炳树 周旭洪__陈炳树 周旭洪
已确定__薛常鹏 周玲 58__薛常鹏 周玲 58
已确定_12678_张思为 彭碧霞
已确定_白翔翰 张英男_白翔翰 张英男
陈永娥
卢欢 郑盈
李王琴
陈炳树 周旭洪
薛常鹏 周玲
张思为 彭碧霞
白翔翰 张英男
Private Declare Function SendMessagebyString Lib _
"user32" Alias "SendMessageA" (ByVal hWND As Long, _
ByVal wMsg As Long, ByVal wParam As Long, _
ByVal lParam As String) As Long
Private Const LB_FINDSTRINGEXACT = &H1A2
Private Sub Command1_Click()
Dim i As Integer, j As Integer
Dim strData As String, strTmp As String
Dim strLine() As String, strItem() As String
strData = "陈永娥 13325357396" & vbCrLf & _
"卢欢 郑盈" & vbCrLf & _
"已确定__李王琴 1__李王琴" & vbCrLf & _
"已确定__陈炳树 周旭洪__陈炳树 周旭洪" & vbCrLf & _
"已确定__薛常鹏 周玲 58__薛常鹏 周玲 58" & vbCrLf & _
"已确定_12678_张思为 彭碧霞" & vbCrLf & _
"已确定_白翔翰 张英男_白翔翰 张英男"
strData = Replace(strData, "已确定_", "")
strData = Replace(strData, "_", " ")
strData = Replace(strData, vbCrLf & " ", vbCrLf)
For i = 1 To Len(strData)
If Asc(Mid(strData, i, 1)) < 0 Or Mid(strData, i, 1) = Space(1) Or Mid(strData, i, 1) = vbCr Or Mid(strData, i, 1) = vbLf Then
strTmp = strTmp & Mid(strData, i, 1)
End If
Next i
Do While InStr(strTmp, Space(2))
strTmp = Replace(strTmp, Space(2), Space(1))
Loop
List1.Clear
strLine = Split(strTmp, vbCrLf)
For i = 0 To UBound(strLine)
strItem = Split(strLine(i), Space(1))
For j = 0 To UBound(strItem)
If -1 = SendMessagebyString(List1.hWND, LB_FINDSTRINGEXACT, -1, Trim(strItem(j))) Then
List1.AddItem Trim(strItem(j))
List1.ItemData(List1.NewIndex) = i
End If
Next j
Next i
ReDim strItem(UBound(strLine))
For i = 0 To List1.ListCount - 1
If List1.List(i) > "" Then strItem(List1.ItemData(i)) = strItem(List1.ItemData(i)) & List1.List(i) & " "
Next i
List2.Clear
For i = 0 To UBound(strItem)
List2.AddItem strItem(i)
Next i
End Sub
Private Sub TestReg()
Dim strData As String
Dim reg As Object
strData = "陈永娥 13325357396" & vbCrLf & _
"卢欢 郑盈" & vbCrLf & _
"已确定__李王琴 1__李王琴" & vbCrLf & _
"已确定__陈炳树 周旭洪__陈炳树 周旭洪" & vbCrLf & _
"已确定__薛常鹏 周玲 58__薛常鹏 周玲 58" & vbCrLf & _
"已确定_12678_张思为 彭碧霞" & vbCrLf & _
"已确定_白翔翰 张英男_白翔翰 张英男"
Set reg = CreateObject("vbscript.regExp")
reg.Global = True
reg.IgnoreCase = True
reg.MultiLine = True
reg.Pattern = "[^\u4e00-\u9fa5\r\n ]|已确定"
Debug.Print reg.Replace(strData, " ")
End Sub