Move Address2 into Address if Address is empty.

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Donna
Site Admin
Posts: 2733
Joined: Mon Mar 18, 2013 9:15 am

Move Address2 into Address if Address is empty.

Post by Donna » Thu Aug 15, 2013 2:29 pm

If you have ADDRESS 2 information but your ADDRESS is blank. The following command will move the ADDRESS 2 information into the ADDRESS. If the ADDRESS field is empty.

Code: Select all

Replace address with ALLT(address2),address2 with "" FOR EMPTY(address)

Post Reply