用replace 也是可以一下就得到了 下面这是用mid得到的 Dim Str As String Dim AA As Integer Str = ";200 ;300 ;400 ;20.3 ;5002.4" AA = InStr(Trim(Str), ";") Do While AA = 1 Str = Mid(Trim(Str), AA + 1) AA = InStr(Trim(Str), ";") LoopDo While AA > 0 Str = Mid(Trim(Str), 1, AA - 1) & Mid(Trim(Str), AA + 1) AA = InStr(Trim(Str), ";") Loop Me.Text1.Text = Str
你用replace不是把所有的数字弄成一个串了吗?用split直接就分成一个字符数组,每个数字都分开了。 Dim Str As String Dim AA Str = ";200 ;300 ;400 ;20.3 ;5002.4" AA = Split(Str, ";")这样AA(0)="",AA(1)="200",AA(2)="300",AA(3)="400",AA(4)="20.3",AA(5)="5002.4" 不是更方便使用吗?
Dlugger() 的split不知怎么用。
下面这是用mid得到的
Dim Str As String
Dim AA As Integer
Str = ";200 ;300 ;400 ;20.3 ;5002.4"
AA = InStr(Trim(Str), ";")
Do While AA = 1
Str = Mid(Trim(Str), AA + 1)
AA = InStr(Trim(Str), ";")
LoopDo While AA > 0
Str = Mid(Trim(Str), 1, AA - 1) & Mid(Trim(Str), AA + 1)
AA = InStr(Trim(Str), ";")
Loop
Me.Text1.Text = Str
Dim Str As String
Dim AA
Str = ";200 ;300 ;400 ;20.3 ;5002.4"
AA = Split(Str, ";")这样AA(0)="",AA(1)="200",AA(2)="300",AA(3)="400",AA(4)="20.3",AA(5)="5002.4"
不是更方便使用吗?