Function String Manipulations Class

ShiftStringLeft

Shifts the characters within a string to the left by vPositions. Same as removing the first vPositions characters from vValue.

Signature (Visual Basic / VBA)

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

Code Example

    ShiftStringLeft("123456789", 3) = "456789"

Parameters

Parameter Description
vValue The string whose characters are to be shifted to the left. 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 greater than the length of the string vValue, in which case an empty string is returned. vPositions can be negative in which case the string is shifted to the right.