Function String Words Class

RotateWordsRight

Rotate/move the last word within the string vValue to the beginning of the string.

Signature (Visual Basic / VBA)

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

Code Example

    RotateWordsRight("111 222 333") = "333 111 222"
    RotateWordsRight("This is a test.") = "test. This is a"
    RotateWordsRight("This is a  test.") = "test. This is a "
    RotateWordsRight("test. This is a ") = " test. This is a" ' 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.