How to make company names typed on two or more lines match with single-lined dataset entry


Company name is typed on two or more lines in the Invoice and does not match with single-lined dataset entry in the Invoice project where Vendor or BU are defined exclusively by name.


The values should match exactly, if they are split between different lines number, then they cannot match.


Here is a sample of this situation:


In this case, the most practical solution is using of the AutoCorrection script: 

Here are the key point to write the script:
1. Read recognized value.
2. Split value to an array of strings by separators like 'space' and 'line break'.
3. Collect a new string from an array, divided by spaces (no line breaks).
4. Write the resulting string in the VendorName or BUName field.

Have more questions? Submit a request



Please sign in to leave a comment.