dim a() as string a = Split("U1.5-10", "-") debug.print a(0),a(1)
Dim 本厂编号 As String, SubString() As String 本厂编号 = "U1.5-10"SubString = Split(本厂编号, "-")Debug.Print SubString(0) Debug.Print SubString(1)
private sub SplitString (byval sCode as string ,byref lStr as string ,byref rStr as string) dim sTemp() as string dim i as integer
if len(sCode ) >0 then sTemp = split(sCode ,"-") if ubound(sTemp)>0 then lStr = Trim(sTemp(0)) rStr = Trim(sTemp(1)) endif else lStr ="" rStr ="" endif end sub '调用语句 dim b as string ,c as string SplitString "U1.5-10",b,c msgbox b & vbcrlf & c
如果访问Access里:left(本厂编号,instr(本厂编号,"-")-1)和mid(本厂编号,instr(本厂编号,"-")+1)
如果访问SQL Server:left(本厂编号,charindex('-',本厂编号,0)-1)和substring(本厂编号,charindex('-',本厂编号,0)+1,len(本厂编号))
s = "U1.5-10"
i% = InStr(s, "-") ' - 在第几个字符
s1 = Left(s, i% - 1) ' U1.5
s2 = Right(s, Len(s) - i%) ' 10
a = Split("U1.5-10", "-")
debug.print a(0),a(1)
本厂编号 = "U1.5-10"SubString = Split(本厂编号, "-")Debug.Print SubString(0)
Debug.Print SubString(1)
private sub SplitString (byval sCode as string ,byref lStr as string ,byref rStr as string)
dim sTemp() as string
dim i as integer
if len(sCode ) >0 then
sTemp = split(sCode ,"-")
if ubound(sTemp)>0 then
lStr = Trim(sTemp(0))
rStr = Trim(sTemp(1))
endif
else
lStr =""
rStr =""
endif
end sub
'调用语句
dim b as string ,c as string
SplitString "U1.5-10",b,c
msgbox b & vbcrlf & c