How to add a common Text "Interest" into Reconciliation reference field with using Parse Rule set
In my current client we are using the Parse rule set to fetch the data from Account servicer reference to Reconciliation reference with using rule as "(X~)", but the client wants to add a common word "Interest" in addition to Reconciliation reference.
Below is the example:
Bank statement Account servicer reference: 672341
Based on below Parse rule set fetching in Reconciliation reference: 672341
Common Text is "Interest" (This word we are not getting in Bank statement file)
Expected Reconciliation reference is "672341-Interest"