Support 805.461.7300
Sales
Our Technology. Your Success.

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,./ ],"")," "))

« Back to Commands

Just wanted whoever receives this to know that AccuZIP6 has the best technical support people ever--in any industry. Without Exception they get my vote for #1.
P.D., Silver Spring, MD