You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Transaction Matching - Calculation Definition (Extract Text)

Accepted answer
30
Views
12
Comments
edited Mar 12, 2020 3:41PM in Account Reconciliation 12 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!