Dim P1 As Long, P2 As Long, n As Long, m As Long, Text1.text="........3wangjiang 4liumin 5chenlu abcdefg" P1 = InStr(1, Text1.Text, 3) P2 = InStr(1, Text1.Text, 4) n = P1 + 1 m = P2 - P1 - 1 Text2.Text = Mid(Text1.Text, n, m) 运行结果text2.text="wangjiang " 如果把这段程序加入循环中,在最后一次时就会出现text2.text="chenlu abcdefg" 这个abcdefg是我不希望的。这里如何以姓名后的空格来作为结束
str = " kkk aaa bbb 4f 4fdao nww 3wangjiang 4liumin f4x 420fa............" dim l as long, r as long l =instr(str, 1, "3") r = instr(str, l+1, " 4") if l<>0 and r <>0 then debug.print mid(str, l, r-l) endif
然后用MID¥
Text1.text="........3wangjiang 4liumin 5chenlu abcdefg"
P1 = InStr(1, Text1.Text, 3)
P2 = InStr(1, Text1.Text, 4)
n = P1 + 1
m = P2 - P1 - 1
Text2.Text = Mid(Text1.Text, n, m)
运行结果text2.text="wangjiang "
如果把这段程序加入循环中,在最后一次时就会出现text2.text="chenlu abcdefg" 这个abcdefg是我不希望的。这里如何以姓名后的空格来作为结束
dim l as long, r as long
l =instr(str, 1, "3")
r = instr(str, l+1, " 4")
if l<>0 and r <>0 then
debug.print mid(str, l, r-l)
endif