Remove Non-keyboard characters from any field

Use this command to remove any character from a field that cannot be typed from the Keyboard

REPLACE ALL company WITH REDUCE(CHRTRAN(company,CHRTRAN(CHRTRAN(company,"[]",""),[~!@#$%^&*()_+`1234567890-=\|}{POIUYTREWQqwertyuiop\":LKJHGFDSAasdfghjkl;'?><MNBVCXZzxcvbnm,./ ],"")," "))

REPLACE ALL company WITH REDUCE(CHRTRAN(company,CHRTRAN(CHRTRAN(company,"[]",""),[~!@#$%^&*()_+`1234567890-=|}{POIUYTREWQqwertyuiop\":LKJHGFDSAasdfghjkl;'?><MNBVCXZzxcvbnm,./ ],"")," "))

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

Would you please pass along to the rest of the AccuZIP team how refreshing it is to have great support? I was an Accuzip customer for several years and left almost 2 years ago thinking the grass was greener on the Bulk Mailer side of the fence. BOY WAS I WRONG! It was one of the worse decisions I made in a long time and actually switched back before my subscription was up with them, paying for an entire year of their software without using it. Eric welcomed me back, and your team got us up and running in no time. The tech support with BCC which gobbled up Bulk Mailer was horrid at best. Very sterile and no personalities or willingness to help at all when you actually were able to talk with someone.

C.H., Sandusky, OH