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. |