These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#33001 - 07/14/10 11:18 AM Help with Expressions
ShawnG Offline
Junior Member

Registered: 07/14/10
Posts: 1
Loc: Pittsburgh PA
I am newer to PSM7 and am having trouble with expressions with regards to empty data.
I am setting up a document and what I want to do is this:

I have a field called ACCT1. I would like to have the expression say.
If the field contains any data at all print he words

#33002 - 07/16/10 02:58 AM Re: Help with Expressions
Sander vd Berg Offline
OL Expert

Registered: 06/10/08
Posts: 207
Loc: Objectif Lune NL
- You can use TRIM to remove any whitespace in case the field is not completely empty.
- Strings can be concatenated with the "&" operator.
- The IF function expects three arguments, there should be two commas separating the arguments.

IF (TRIM([Acct1]) <> "", "Your account ending in " & [Acct1], "")