Function String Searches Class

GetTokenAlphanumeric

"Get Alphanumeric Token" Remove the first alphanumeric token from the argument and return the token. Function skips leading non-alphanumeric characters (spaces, tabs, symbols, punctuation, etc.) before returning the first alphanumeric token.

Signature (Visual Basic / VBA)

Public Function GetTokenAlphanumeric( _
    ByRef rValue As Variant _
    ) As Variant

Code Example

    Assuming
       Dim S As String
       S = "   First Second    Third"
    for example
       GetTokenAlphanumeric(S) = "First"
    leaves
       S = "Second    Third"

Parameters

Parameter Description
rValue The string containing the alphanumeric tokens of which the first is to be removed and returned. Function returns Null if rValue is Null or cannot be fixed up to a String.