how to force blank line at end of CSV
SummaryEnd-of-File character is at end of last line, we need it to be on a blank line below that
We were recently upgraded to OBIEE 18.104.22.168.0. We also moved to a new data centre. Since then, it appears that something has changed on us, which is causing us a problem.
We do not use TCC - at least, not at the moment.
Every morning, we manually run an OBIEE report and save it as CSV. Then we upload that to our HRIS for processing. Since the above two changes occurred, it appears as though the End-of-file character has changed positions. It used to exist on a blank row of its own at the end of the file. Now it is on the same row as the last row of data. This is causing our upload process to fail.