Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Removing Blank Lines from an ACH rtf

Received Response
41
Views
2
Comments

Summary

Removing Blank Lines from an ACH rtf

Content

The bank I am working with can only accept NACHA files in blocks of 10 lines. For this, I created a code that will allow the Placeholder lines to populate depending on the payment count in the ACH file.

For example:

If there is only one payment line in the NACHA file, I will need 4 'Placeholder lines' to create a block of 10 lines.

If there are two payment lines, then I will only need 3 'Placeholder lines' to create a block of 10 lines.

3 Payments = 2 Placeholder Lines.

4 Payments = 1 line

5 Payments = No placeholder lines.

The issue comes with the output. The TXT file will only show 10 lines of text to the naked eye, but it actually creates 12 lines and the bottom two are just blank.

I need some kind of code to place in my RTF that will completely remove the lines that have no information in them.

Attached is the code for the placeholder lines and and example of the nacha output file with the 2 extra blank lines.

Any help is appreciated!

Answers