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
- Posts: 1910
- Joined: Tue Sep 19, 2006 3:29 pm
Use this command to mark Invalid ZIP Codes in your database. This makes it so you can identify Invalid ZIP Codes in a script, as you won't have to pull down Select to Show > Invalid ZIP Codes.
Code: Select all
REPLACE x WITH "X" FOR EMPTY(SUBSTR(GetLineValue(ADDBS(xDefFldr)+"AZCTYSTATE.txt",VAL(LEFT(zip,5))+1,35),6,1))
When you export your data or when you show Marked records, look for a capital X in the x field. These will be your Invalid ZIP Code records.