自己编吧。Function getString(sSrc As String, cKey As String) As String Dim iLen As Integer Dim i As Integer Dim cChar As String Dim flag As Boolean Dim sResult As String Dim iBegin As Integer
iLen = Len(sSrc) For i = 0 To iLen cChar = Mid(sSrc, i + 1, 1) If cChar = cKey Then If flag Then
Exit For Else iBegin = i flag = True End If End If Next i
sResult = Mid(sSrc, iBegin + 1, i - iBegin) getString = sResult End FunctionsSrc是源字符串,cKey为你要找的符号,例如Private Sub Form_Load() Dim ss As String ss = "asdfasdf'fdfdfdfd'fdfdf" Print getString(ss, "'")End Sub会输入出fdfdfdfd 试试看,
Dim iLen As Integer
Dim i As Integer
Dim cChar As String
Dim flag As Boolean
Dim sResult As String
Dim iBegin As Integer
iLen = Len(sSrc)
For i = 0 To iLen
cChar = Mid(sSrc, i + 1, 1)
If cChar = cKey Then
If flag Then
Exit For
Else
iBegin = i
flag = True
End If
End If
Next i
sResult = Mid(sSrc, iBegin + 1, i - iBegin)
getString = sResult
End FunctionsSrc是源字符串,cKey为你要找的符号,例如Private Sub Form_Load()
Dim ss As String
ss = "asdfasdf'fdfdfdfd'fdfdf"
Print getString(ss, "'")End Sub会输入出fdfdfdfd
试试看,