Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Removing Blank Lines from an ACH rtf
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
-
-
Bump
0