PAD (string padding)

PAD instruction in combination with LENGTH allows to expand string variable with the spaces at the end to the desired string length.

Related topic

PRL-control-statement-verbs

Syntax 

PAD <variable> TO LENGTH <nn>

where

  • variable is the name of a variable or array element to be padded with the spaces
  • nn is the length of the variable after command execution.

Example

SET &STR = 'TEXT'                  --> &STR has length of 4 characters
PAD &STR TO LENGTH 10              --> &STR has length of 10 characters and its value is 'TEXT      '

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*