PADRIGHT
Pads out a string to the right.
Syntax
string PADRIGHT(string value, int num)
string PADRight(string value, string character, int num)
Inputs
| Object | Data Type | Description |
|---|---|---|
| value | String | The string to pad out. |
| character | String | The character to use to pad out the string. |
| num | Integer | The 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.