1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
Dim WC , Pos
If VarType(S) <> 8 Or Len(S) = 0 Then
CountCSWords = 0
Exit Function
End If
WC = 1
Pos = InStr(S, "|")
Do While Pos > 0
WC = WC + 1
Pos = InStr(Pos + 1, S, "|")
Loop
CountCSWords = WC
End Function
Function GetCSWord(ByVal S, Indx)
' Returns the nth word in a specific field.
Dim WC, SPos , EPos
WC = CountCSWords(S)
If Indx < 1 Or Indx > WC Then
GetCSWord = Null
Exit Function
End If
Count = 1
SPos = 1
For Count = 2 To Indx
SPos = InStr(SPos, S, "|") + 1
Next
EPos = InStr(SPos, S, "|") - 1
If EPos <= 0 Then EPos = Len(S)
GetCSWord = Trim(Mid(S, SPos, EPos - SPos + 1))
End Function |
Partager