Debits and Credits are in separate columns. How do you load a flat file in this case?

Summary:

We have a client that uses Quickbooks. The flat file that is being provided for load into Data Integration has a column for debits and a column for credits. What is the best practice for setting up this integration? We tried DRCRSplit but there is a blank column in between.

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):