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

First the kudos. Accuzip, already the best, is even better with the new CASS speed. I don't know how you did it but it is fast, fast, fast!

C.P., Houston, TX