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.
0 Comments