Sub test()
Dim w1 As String, iX As Integer, iY As Integer, iZ As Integer
w1 = "X475Z1.1y26"
iY = InStr(1, w1, "y", vbTextCompare)
iZ = InStr(1, w1, "z", vbTextCompare)
Debug.Print "x=" & Mid$(w1, 2, iZ - 2)
Debug.Print "y=" & Right$(w1, Len(w1) - iY)
Debug.Print "z=" & Mid$(w1, iZ + 1, iY - iZ - 1)
End Sub
Dim w1 As String, iX As Integer, iY As Integer, iZ As Integer
w1 = "X475Z1.1y26"
iY = InStr(1, w1, "y", vbTextCompare)
iZ = InStr(1, w1, "z", vbTextCompare)
Debug.Print "x=" & Mid$(w1, 2, iZ - 2)
Debug.Print "y=" & Right$(w1, Len(w1) - iY)
Debug.Print "z=" & Mid$(w1, iZ + 1, iY - iZ - 1)
End Sub
解决方案 »
- VarType的一个奇怪现象
- vb基础问题 关于or
- 请问0X80000001的字节流的问题(急)
- sql查询问题:Me.Adodc1.RecordSource = "select * from data where haoma = '12345'"
- 为什么field(index).name属性不正确?
- VB6 如何调用Hide.dll
- 大侠 我连ActiveX DLL都不会啊 救我呀!
- 在对 多表的 连接查询中的 RECORDSET中
- 高分求教:有一个9x和2k组成的简单的对等网,怎样才能得到所有机器的名称及其ip?
- 用Vb怎么对DirectX编程?我想找一些入门的书哪有?
- 在VB中编程,大于等于60分显示及格,小于60分显示不及格
- 请教将下面代码编译成为dll文件
Dim i As Integer, x(2) As String, k As Integer
Dim w2 As String, w1 As String
w1 = "X475Z1.1y26"
For i = 1 To Len(w1)
w2 = LCase$(Mid$(w1, i, 1))
Select Case w2
Case "x": k = 0
Case "y": k = 1
Case "z": k = 2
Case Else
x(k) = x(k) + w2
End Select
Next
Debug.Print "x=" & x(0) & "; y=" & x(1) & "; z=" & x(2)
End Sub