Topic Options
#36352 - 06/14/11 10:55 AM Address block - Left justify when cell blank
Drewie Offline
OL Newbie

Registered: 06/04/10
Posts: 8
Loc: Worcester. UK
Hi,
Some of the data we recive for mailings has a field for the TITLE (Mrs, Mrs etc), however not every cell is populated. The problem I have is that the First name does then not move all the way across to the left.

Example
Mr Joe Smith
_Alan Get
Miss Ann Let
_Drew Sail

Can I get round this?

Top
#36357 - 06/14/11 03:01 PM Re: Address block - Left justify when cell blank [Re: Drewie]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4953
Loc: Objectif Lune Montreal
Drewie,

If you put a static space between the title variable and the first name variable, it will always be there, even if the TITLE field is empty. So you need to make that space conditional.

Start by removing the static space between the title and the first name. Then, go in the expression editor for the variable that displays the title(right-click on your text box, choose Edit Expression, and choose your variable, or double-click on the variable in your list of variables that you can display by going to the Window menu, and choosing Variables).

You will use an expression similar to this one:

IF([TITLE] <> "", [TITLE] & " ", "")

What will happen is that if the TITLE field is not empty, it will display it, along with a space. If it's empty, however, it will not display anything, and it will not put a space.

Hope that helps!

Regards,
Raphaƫl Lalonde Lefebvre

Top
#36414 - 06/22/11 11:17 AM Re: Address block - Left justify when cell blank [Re: Raphael Lalonde Lefebvre]
Drewie Offline
OL Newbie

Registered: 06/04/10
Posts: 8
Loc: Worcester. UK
Merci beaucoup Raphael,

Anthony.

Top