Remove Blank Spaces


How do I remove unwanted characters such as tildes, spaces, punctuation marks, etc. from a field after a DB lookup routine, or OCR result, etc.?


Use UtilityQSX and a function called, Replace Characters.  To eliminate spaces from a field, select the DocType (in this example QQQ), select the Source Field ( in this example, OCR Value), select the Target Field (in this example, OCR Value).   in the Old Value, insert a “ followed by the SPACE BAR and end with a “.   In the New Value, leave the field value blank.  If you wanted to remove a tilde (~) value from field contents, replace the SPACE with a “~” with quote encapsulating the ~.   See example attached. 

Have more questions? Submit a request


Article is closed for comments.
Powered by Zendesk