Remove Non-keyboard characters from any field

[Eric]

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

Code: Select all

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

Note: Change “company” to the field name you want to process on.