Not sure about your specific sitaution but I think I would be inclined to filter out ALL blank lines and then attempt to use output formatting to insert the lines you do require at the appropriate points.
There are more obvious controls available for Summary Exports than table exports. Are you exporting from the report, the table or a summary?
Thanks for the prompt response.
I am exporting from a table. The report I am using is an ill formed PDF report where I must do alot of slicing and dicing to get it in the desired format. In addition, many of the data records (lines) are informational and are not part of the desired output.
I thought about filtering all of the blank lines and attempting to define "logical" form feeds; however, the data is medical transcription and therefore has alot of freeform text with no standard "anchors" with which to define a form feed.
I am currently testing a multiple step solution that may get me where I want to be. If not, I am going to use the editor and attempt to us a batch file and macro to automate the process.
Again, thanks for the interest.
Just thinking aloud here but I was wondering if you could export as it is to a new 'report' and then re-read it into Monarch using a simple model that, maybe, grabs multi-line blanks as a single field but display that in limited form in the new table and then make it a single line on an export from there.
Or something like that.
Alternatively could the entire table, empty lines filtered, go to a Summary where there are more controls available?
Thanks for your help.
I have spent alot of time on this and came up with a better solution than an editor. In a multi-step process, I create one export to include a formula to look at the current line and the line above it to determine if they are both blank. If so, the current line is marked so that I can filter it out in the next step.
I wanted to get rid of the need for the editor because it would require a license for the users that would use this process. Excel is included for all users, so this solves the problem.