also be done using @Functions like this:
StringToPad := "3456";
StringLength := 10;
PadChar := "0";
RightPad := @Left(StringToPad + @Repeat(PadChar; StringLength); StringLength);
LeftPad := @Right(@Repeat(PadChar; StringLength) + StringToPad ; StringLength)
Function RightPad(StringToPad As String, StringLength As Integer, PadChar as
String) As String
FLength%= StringLength - Len(StringToPad)
If Len(PadChar) = 0 Then PadChar = " "
FTemp$ = String$(StringLength, PadChar)
If FLength% <= 0 Then
RightPad = StringToPad
Else
RightPad = Left$(StringToPad & FTemp$, StringLength)
End If
End Function
Function LeftPad(StringToPad As String, StringLength As Integer, PadChar as
String) As String
FLength%= StringLength - Len(StringToPad)
If Len(PadChar) = 0 Then PadChar = " "
FTemp$ = String$(StringLength, PadChar)
If FLength% <= 0 Then
LeftPad = StringToPad
Else
LeftPad = Right$(FTemp$ & StringToPad, StringLength)
End If
End Function
This was first published in November 2000