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

As always, thanks for your product. We in the industry TRULY appreciate the fact that YOU get back to us. You have NO IDEA how important that is.
T.G., Berlin, MD