text3中显示出在text1中不在text2中字符Dim SStart As Integer Dim SEnd As Integer Dim length As Integer Dim tempStr As String Text3.Text = "" SStart = 1 Do While SStart <= Len(Text2.Text) SEnd = InStr(SStart, Text1.Text, ",") If SEnd = 0 Then Exit Do length = SEnd - SStart + 1 tempStr = Mid(Text1.Text, SStart, length) SStart = SEnd + 1 Debug.Print InStr(1, Text2.Text, tempStr) If InStr(1, Text2.Text, tempStr) = 0 Then Text3.Text = Text3.Text & tempStr End If Loop 运行结果: T,e,x,t1,T,e,x,t2,t1, 给分!!
Dim SStart As Integer Dim SEnd As Integer 循环条件写错了Do While SStart <= Len(Text2.Text), 更正为:Do While SStart <= Len(Text1.Text)Dim length As Integer Dim tempStr As String Text3.Text = "" SStart = 1 Do While SStart <= Len(Text1.Text) SEnd = InStr(SStart, Text1.Text, ",") If SEnd = 0 Then Exit Do length = SEnd - SStart + 1 tempStr = Mid(Text1.Text, SStart, length) SStart = SEnd + 1 If InStr(1, Text2.Text, tempStr) = 0 Then Text3.Text = Text3.Text & tempStr End If Loop
循环条件写错了Do While SStart <= Len(Text2.Text) 更正为:Do While SStart <= Len(Text1.Text)
text3中显示出在text1中不在text2中字符Dim SStart As Integer
Dim SEnd As Integer
Dim length As Integer
Dim tempStr As String
Text3.Text = ""
SStart = 1
Do While SStart <= Len(Text2.Text)
SEnd = InStr(SStart, Text1.Text, ",")
If SEnd = 0 Then Exit Do
length = SEnd - SStart + 1
tempStr = Mid(Text1.Text, SStart, length)
SStart = SEnd + 1
Debug.Print InStr(1, Text2.Text, tempStr)
If InStr(1, Text2.Text, tempStr) = 0 Then
Text3.Text = Text3.Text & tempStr
End If
Loop
运行结果:
T,e,x,t1,T,e,x,t2,t1,
给分!!
Dim SEnd As Integer
循环条件写错了Do While SStart <= Len(Text2.Text),
更正为:Do While SStart <= Len(Text1.Text)Dim length As Integer
Dim tempStr As String
Text3.Text = ""
SStart = 1
Do While SStart <= Len(Text1.Text)
SEnd = InStr(SStart, Text1.Text, ",")
If SEnd = 0 Then Exit Do
length = SEnd - SStart + 1
tempStr = Mid(Text1.Text, SStart, length)
SStart = SEnd + 1
If InStr(1, Text2.Text, tempStr) = 0 Then
Text3.Text = Text3.Text & tempStr
End If
Loop
更正为:Do While SStart <= Len(Text1.Text)