Transaction Matching - Calculation Definition (Extract Text)

Content

Hi everyone,

We are implementing Transaction Matching on a Client and one of the source file has column that has a text on it.  For this column we need to extract the last 4 digits, these digits will be use in the matching rule.  The only available option on the system that can extract text that we see is SUBSTRING(<Value>, <Location>, <Length>) the issue with this is that the length of the text column vary and not always is on the same position. We know the user can edit the file before importing the file, but we want to avoid this and upload the file as is come from the source through