How to handle void payments from Bank file which are coming from BAI

Summary:

From BAI receiving 252 reversal transactions(Void payment transaction) like

16,252,30,,,,REVERSAL 062-770 001016225 XXXXXX 533816 2024-04-02 207831502
88,005 NO ACCOUNT OR INCORRECT ACCOUNT NUMBER

Reference and Payment number are part of Bank text hence DM unable recongnise the Payment number /Customer Ref

Do I need to tweak the data after loading into Staging via #SQL or Is there any direct method

in DM I do see error like

Error at line no 19 : Attribute "Customer Ref" value required.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):