Builds a character expression from a different one, by adding a specific character N times, or blanks to the left.
Padl(Str, Len [,FillChar])
Where:
Str
Is the character expression from which you want to add left blanks or with the FillChar if indicated.
Len
Is the numeric expression that indicates the length of the returned string.
FillChar
Is the character to be added on the left 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 on the right, which is the result of concat the specified ‘FillChar’, ‘len’ times on the left of the ‘Str’ specified for the function.
PadL(“My string”, 14) = “ My string”
PadL(“My string”, 14, ‘*’) = “*****My string”
PadLeft method
PadR function
Trim function
LTrim function
RTrim function