AccuZIP6 Users Community Forum Index AccuZIP6 Users Community
Tech Support, product information, postal news, and everything else concerning AccuZIP6
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Remove Non-keyboard characters from any field

 
Post new topic   Reply to topic    AccuZIP6 Users Community Forum Index -> AccuZIP6 Commands
View previous topic :: View next topic  
Author Message
Eric
Moderator


Joined: 19 Sep 2006
Posts: 382
PostPosted: Thu Feb 25, 2010 4:57 pm    Post subject: Remove Non-keyboard characters from any field Reply with quote
Use this command to remove any character from a field that cannot be typed from the Keyboard:

Code:
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.
_________________
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    AccuZIP6 Users Community Forum Index -> AccuZIP6 Commands All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group