User Support Forum

Posted: **Wed Nov 24, 2010 12:41 pm**

I want to print addresses on the same line as the name. In the Edit Output Fields I have:
... Address Line 1, address line2, City + state + zip/postal
such as ..... 1534 Elm St, Manor Rm 102, Anywhere WI 76543

I'm trying to use the ALLTRIM command but the following spaces are not getting trimmed.
Please advise.

Posted: **Wed Nov 24, 2010 12:53 pm**

What is the actual expression that you have in that field?

it should look like this:

Code: Select all

alltrim(address)+", "+alltrim(address2)+", "+alltrim(city)+", "+alltrim(state)+" "+alltrim(zip)

Posted: **Tue Nov 30, 2010 3:51 pm**

Zorak, thanks. Using your example I get ,, whenever there is a missing field in the address. So what I did was created: IIF( statements to check for NOT EMPTY on each field.
Thanks.

Posted: **Tue Nov 30, 2010 4:31 pm**

Yes, that is what you would need to do on each of the fields. Glad to hear you got it working

User Support Forum

I want to print full address on 1 line.

I want to print full address on 1 line.

Re: I want to print full address on 1 line.

Re: I want to print full address on 1 line.

Re: I want to print full address on 1 line.