Skip to main content

PADRIGHT

Pads out a string to the right.

Syntax

string PADRIGHT(string value, int num)
string PADRight(string value, string character, int num)

Inputs

ObjectData TypeDescription
valueStringThe string to pad out.
characterStringThe character to use to pad out the string.
numIntegerThe number which corresponds to the length of the string once padding is complete.

Example

To fulfil the character length required for a specific field, you can use PADRIGHT to increase the number of characters with a specified string character:

PADRIGHT("Simego","*", 8)

Which would return "Simego**".

NB: If you do not enter a string character to PAD with, the default is a space e.g:

PADRIGHT("Simego", 10)

Will return Simego     which will look like "Simego    " in the UI.