2011-03-29
Dismiss this until next updateThis documentation has been updated

The latest version of PrintShop Mail is currently 7.1. This documentation was updated on 2011-03-29 and covers the changes made in this version. If you are still using an older version of PrintShop Mail, you can access its documentation by using the Version: menu at the top-right corner of this screen.

If you wish to upgrade to PrintShop Mail7.1, you can do so via the Upgrade Request page. Note that in order to upgrade, you will need a valid OL Care contract as of 2010-09.

Padding a string

You can use an expression to automatically pad a string or number to a certain number of positions, by using a combination of the RIGHT() function and by concatenating the string with the characters you want to pad with.

Example: Padding a string with dots (periods) to 20 positions:

RIGHT("...................." & [DataField], 20)

Result (if [DataField] contains "Example"):

.............Example

Example: Padding a 5-digit zip code with zeroes, to 5 positions (this is useful if PrintShop Mail sees the zip code as a number and removes the zeroes automatically):

RIGHT("00000" & [ZipCode], 5)

Result (if [ZipCode] is 1234):

01234