求字符串,用"[]"分隔中的内容如 IF [H1] > [C5] THEN 要求返回 H1 , C5 如上 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Private Function GetPiece(ByVal psExpr As String) As String() Dim lCol As Long, lRow As Long Dim i As Long Dim nLen As Long Dim lStart As Long Dim lLength As Long Dim ch As String Dim lSplit As Long Dim Result() As String ReDim Result(0) nLen = Len(psExpr) lSplit = 1 Do While lSplit < nLen For i = lSplit To nLen ch = Mid(psExpr, i, 1) If ch = "[" Then lStart = i lLength = 0 ElseIf ch = "]" Then lSplit = lStart + lLength + 1 lSplit = lSplit + 1 ch = Mid(psExpr, lStart + 1, lLength) ReDim Preserve Result(UBound(Result) + 1) Result(UBound(Result)) = ch Exit For Else lLength = lLength + 1 lSplit = lSplit + 1 End If Next Loop Result(0) = UBound(Result) GetPiece = Result End Function 各位高手们!请赐教~~~~~~~~~ 怎么用VB编写DLL,请告知如何编写(举例)。 关于刷新的小问题,但很急! 一个有关ListView控件的问题 这样的问题如何解决,再现等待 数据删除的问题求救 程序员的20种死法---搞笑,呵呵! ShellAbout的用法 Listview中更新?双儿 请问:TabStrip这个控件怎么用呀? 子查询的问题? 请教:两个应用程序间相互通讯的问题?
Dim lCol As Long, lRow As Long
Dim i As Long
Dim nLen As Long
Dim lStart As Long
Dim lLength As Long
Dim ch As String
Dim lSplit As Long
Dim Result() As String
ReDim Result(0)
nLen = Len(psExpr)
lSplit = 1
Do While lSplit < nLen
For i = lSplit To nLen
ch = Mid(psExpr, i, 1)
If ch = "[" Then
lStart = i
lLength = 0
ElseIf ch = "]" Then
lSplit = lStart + lLength + 1
lSplit = lSplit + 1
ch = Mid(psExpr, lStart + 1, lLength)
ReDim Preserve Result(UBound(Result) + 1)
Result(UBound(Result)) = ch
Exit For
Else
lLength = lLength + 1
lSplit = lSplit + 1
End If
Next
Loop
Result(0) = UBound(Result)
GetPiece = Result
End Function