Im new to this board and also to this product so Im not sure if this question has already been answered. Im currently doing a mailing and the data has a first, middle and last name but the problem is not all of the data has a middle and the program puts a space in for the middle name when there isnt one there. How do I get rid of the space.

Example:

Thomas R. Smith (with middle)

Jane[space} Smith (with space that I want gone)

Hi,

Sorry for the confusion. I thought you wanted to remove an empty line.

In your case what you could do is something like this.

You would create an expression for your First Name field.

You would remove the space in the text box and add it manually if we need it or not.

You could do something like this.

if([Middle Name]="",[First Name], [First Name]&" ")

So if Middle Name is empty then just show the First Name and if Middle Name is not empty it will display the First Name and add a space.

Let me know if that is what you were looking for.

Thanks,

Marc

Ok,

If you want to get rid of blank lines...

Application would be personalized notepad and when published to web, would contain following data fields :

[Name]
[Office]
[Address]
[Phone number]
[Mobile number]
[Email]

When ordered, customer can leave any of the fields empty.

If name is given it will be printed in bold.

If customer leaves [Office] and [Phone Number], result would be :

[Name] (printed in bold)
[Address]
[Mobile number]
[Email]

Jones

Ah... Figured it out..