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

THANK YOU THANK YOU THANK YOU!! Not only for the WHAT of Accuzip but also, significantly, for the WAY you do what you do! You folks have made a world of difference for me and I sincerely appreciate it! Just couldn't wait to let you know how thrilled I really am.

J.P., Santa Monica, CA