如何用VB截取空格字符间的资料

2025-03-27 13:47:39
推荐回答(2个)
回答1:

Dim ss As String, s() As String, i As Integer
ss = "A5642 18K +/-1%或C5644 2K +/-5%或H2344 15K9 +/-10%"
s = Split(ss, " ")
For i = 0 To UBound(s)
Print s(i)
Next

回答2:

str="A5642 18K +/-1%"

P1=InStr(1,str," ")
P2=InStr(P1+1,str," ")

str1=mid(str,p1+1,p2-p1)