'================================================== '函數名：GetPaing '作 用：獲取分頁 '================================================== Function GetPaing(Byval ConStr,StartStr,OverStr,IncluL,IncluR) If ConStr="$False$" or ConStr="" Or StartStr="" Or OverStr="" or IsNull(ConStr)=True or IsNull(StartStr)=True Or IsNull(OverStr)=True Then GetPaing="$False$" Exit Function End If
Dim Start,Over,ConTemp,TempStr TempStr=LCase(ConStr) StartStr=LCase(StartStr) OverStr=LCase(OverStr) Over=Instr(1,TempStr,OverStr) If Over<=0 Then GetPaing="$False$" Exit Function Else If IncluR=True Then Over=Over+Len(OverStr) End If End If TempStr=Mid(TempStr,1,Over) Start=InstrRev(TempStr,StartStr) If IncluL=False Then Start=Start+Len(StartStr) End If
If Start<=0 Or Start>=Over Then GetPaing="$False$" Exit Function End If ConTemp=Mid(ConStr,Start,Over-Start)
ConTemp=Trim(ConTemp) ConTemp=Replace(ConTemp," ","") ConTemp=Replace(ConTemp,",","") ConTemp=Replace(ConTemp,"'","") ConTemp=Replace(ConTemp,"""","") ConTemp=Replace(ConTemp,">","") ConTemp=Replace(ConTemp,"<","") ConTemp=Replace(ConTemp," ","") GetPaing=ConTemp End Function
