Function String Words Class

RotateWordsLeft

Rotate/move the first word within the string vValue to the end of the string.

Signature (Visual Basic / VBA)

Public Function RotateWordsLeft( _
    ByVal vValue As Variant _
    ) As Variant

Code Example

    RotateWordsLeft("111 222 333") = "222 333 111"
    RotateWordsLeft("This is a test.") = "is a test. This"
    RotateWordsLeft("This  is a test.") = " is a test. This"
    RotateWordsLeft(" is a test. This") = "is a test. This " ' Warning!

Parameters

Parameter Description
vValue String containing the phrase which is to have its first space-separated word moved to the end of the string. Function returns Null if vValue is Null or cannot be fixed up to a String.

Notes & Version History

Note Function uses the built-in character classification routines to determine which characters represent spaces.