Builds a character expression from another one, by adding a specific character N times, or blanks to the right.
PadR(Str, Len [,FillChar])
Where:
Str
Is the character expression from which you want to add right blanks or the FillChar if indicated.
Len
Is the numeric expression that indicates the length of the returned string.
FillChar
Is the caracter that is added to the right side of ‘Str’. It is an optional parameter, if it is not specified then blanks will be added.
Type returned:
Character
Objects: Procedure, Transaction, Web Panel, Panel, Data Provider
Generators: .NET, .NET Framework, Java, Apple, Android, Angular
Returns a character string, aligned to the right, which is the result of concat the specified ‘FillChar’ , ‘len’ times to the right side of the ‘Str’ specified to the function.
PadR(“My string”, 14) = “My string ”
PadR(“My string”, 14, ‘*’) = “My string*****”
Note: All trailing spaces from the original string will be removed before applying the function. The implementation of the function is similar to the following:
PadR(string text, int size, string fill)
return Left(RTrim(text) + Replicate(fill, size), size);
PadRight method
PadLeft method
PadL function
Trim function
LTrim function
RTrim function