两个字符串处理函数

个字符串处理函数:
1、ParameterValue()
2、ParameterCount()

用法示例:
dim TheString as String
TheString="欢迎,光临,枕善居,源代码"
msgbox ParameterCount(",",TheString)
返回 4

ParameterValue(",",TheString,2)
返回 "欢迎"


Public Function ParameterCount(ParseCharacter As String, _
    tString As Variant) As Integer
    Dim CurrentPosition As Integer
    Dim ParseToPosition As Integer
    Dim CurrentToken As Integer
    Dim TempString As String
    TempString = Trim(tString) + ParseCharacter
    If Len(TempString) = 1 Then Exit Function
    CurrentPosition = 1
    CurrentToken = 1


    Do
        ParseToPosition = InStr(CurrentPosition, TempString, _
        ParseCharacter)
        CurrentToken = CurrentToken + 1
        CurrentPosition = ParseToPosition + 1
    Loop Until (CurrentPosition >= Len(TempString))
    ParameterCount = CurrentToken - 1
End Function


Public Function ParameterValue(ParseCharacter As String, _
    tString As Variant, _
    Index As Integer) As String
    Dim CurrentPosition As Integer
    Dim ParseToPosition As Integer
    Dim CurrentToken As Integer
    Dim TempString As String
    TempString = Trim(tString) + ParseCharacter
    If Len(TempString) = 1 Then Exit Function
    CurrentPosition = 1
    CurrentToken = 1


    Do
        ParseToPosition = InStr(CurrentPosition, TempString, _
        ParseCharacter)


        If Index = CurrentToken Then
            ParameterValue = Mid$(TempString, CurrentPosition, _
            ParseToPosition - CurrentPosition)
            Exit Function
        End If
        CurrentToken = CurrentToken + 1
        CurrentPosition = ParseToPosition + 1
    Loop Until (CurrentPosition >= Len(TempString))
End Function   
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值