| 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.
T.B., Greenville, SCI just wanted to let your team know how much I appreciate you. I'm still fairly new at doing mail data processing, and it if weren't for your active support -- even for the not so smart questions -- I probably wouldn't be doing as well in this job as I am now. I have much more to learn as I have seen, but I just wanted to say thank you for your help! You all are wonderful!
