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.