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.

TRIM

Syntax

TRIM(Text)

Description

Returns the supplied text, stripped of all leading and training spaces, tabs and newline characters.

Example

TRIM (" 12 ") => 12
Parameter description

Text

String to remove leading and trailing spaces, tabs and newline characters from.

This function removes extra spacing in a combination of variables (for example, when the database has set a defined number of characters for each particular database field or when a database field is left empty).

TRIM removes any extra spacing at the left and at the right side of the word in the database field that has been selected.