Function String Manipulations Class

ReverseEveryNCharacters

Reverse the characters within every set of characters of length vSize.

Signature (Visual Basic / VBA)

Public Function ReverseEveryNCharacters( _
      ByVal vValue As Variant _
    , ByVal vSize As Variant _
    ) As Variant

Code Example

    ReverseEveryNCharacters("ABCDEFGHI", 3) = "CBAFEDIHG"
    ReverseEveryNCharacters("ABCDEFGHIJ", 2) = SwapCharacters("ABCDEFGHIJ") ' #2
    ReverseEveryNCharacters("ABCD", 3)  = "CBAD"  ' #3
    ReverseEveryNCharacters("ABCDE", 3) = "CBAED" ' #4
    ReverseEveryNCharacters("ABCDEFGHI", 1) = "ABCDEFGHI" ' #5

Parameters

Parameter Description
vValue The string containing the sub-strings that are to be reversed. Function returns Null if vValue is Null or cannot be fixed up to a String.
vSize The number of characters within each sub-string. Each sub-string of this size is reversed. Function returns Null if vSize is Null or cannot be fixed up to a number. Calling ReverseEveryNCharacters with a vSize greater than or equal to the length of vValue is like calling the ReverseString function. Calling ReverseEveryNCharacters with a vSize of two is like calling the SwapCharacters function, as in example #2. If the length of vValue is not a multiple of vSize, then the remaining characters at the end of vValue are still reversed, as in examples #3 and #4. vValue is returned as a string but no characters are reversed if vSize is <= 1 (less than or equal to one), as in example #5.