Page 1 of 1

Remove Non-keyboard characters from any field

Posted: Thu Feb 25, 2010 8:57 am
by 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.