Trim Field Length

Question:

How do I trim the length of a field that may have had extraneous characters added to the desired field length due to OCR processing errors or fields that were concatenated? 

Answer:

Use UtilityQSX and a function called, Split Field Value.   Copy the contents of the source field to a secondary field (note: can be a hidden field) and set the starting position and ending position to the desired character count.   See example attachment. 

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk