Remove Non-keyboard characters from any field

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Chrissy, Geoff, Vince

Post Reply
User avatar
Posts: 1912
Joined: Tue Sep 19, 2006 3:29 pm

Remove Non-keyboard characters from any field

Post by Eric » Thu Feb 25, 2010 8:57 am

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.

Post Reply