Question

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

请问如A5642 18K +/-1%或C5644 2K +/-5%或H2344 15K9 +/-10%，如何用VB截取这些字段中用空格分隔的18K或2K或15K9数据，还请帮忙用VB写一下，谢谢。

Answer 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

Answer 2

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

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

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