Function String Manipulations Class

ShiftStringRight

Shifts the characters within a string to the right by vPositions. Same as removing the last vPositions characters from vValue.

Signature (Visual Basic / VBA)

Public Function ShiftStringRight( _
      ByVal vValue As Variant _
    , Optional ByVal vPositions As Variant _
    ) As Variant

Code Example

    ShiftStringRight("123456789", 3) = "123456"

Parameters

Parameter Description
vValue The string whose characters are to be shifted to the right. Function returns Null if vValue is Null or cannot be fixed up to a String.
vPositions The number of positions that each character is to be shifted. vPositions defaults to 1 (one) if it is missing or Null or cannot be fixed up to a number. vPositions can be negative in which case the string is shifted to the left.