PREPEND(data, substring);

Formula used in e.g. Axapta and XAL to where certain values are prepended with blanks.

Example 1:

##PREPEND("NAME",' ',30)

Will insert blanks in front of the Name until total length is 30.

If "NAME" has the value "Mr. John Doe" it will return the result "                  Mr. John Doe".
You can Prepend with any single character you want.

 

Example 2:

##PREPEND("NAME",'x',30)
Will insert x's in front of the Name until total length is 30.

If "NAME" has the value "Mr. John Doe" it will return the result "xxxxxxxxxxxxxxxxxxMr. John Doe".