Hi all,

Question, and I am not even sure if this is possible.
We receive a file from a client on a daily basis. This is in a text format. I need some of the data in it for some reports. Crystal isn't really liking .txt files as dataset, so I created an Access database, linked the text file, and used this as a data-set in Crystal. This works perfect, no issues there.

However, in the .txt file, there is an empty line at the bottom of the report. And that is causing an issue. Because I need to export my report to a .CSV format. And the empty line at the bottom shows on my report. When I open my file in Notepad++, there is the empty line again. And the program where I need to transfer the report to, isn't accepting this.

I tried different ways to get rid of the empty line. I tried suppressing blank sections: didn't work.
I tried every single way of exporting it as .CSV: didn't work.

I am running out of ideas, I really don't want to go into the original file every day (sometimes multiple files a day) to check if there is an empty line, and if so, delete this.

Is there any way to get rid of this?

Any help would be deeply appreciated.

Kind regards

Gerben

There is nothing in the empty line. When I look at the report in Excel, it looks fine. However, when I open it in Wordpad++ is shows that there is an empty line.

I expect the end of the file to be the end of the last line. Now, it looks something like this:

Data;Data;Data;Data;Data;Data
Data;Data;Data;Data;Data;Data
Data;Data;Data;Data;Data;Data
Data;Data;Data;Data;Data;Data
null

And I expect it to look something like:
Data;Data;Data;Data;Data;Data
Data;Data;Data;Data;Data;Data
Data;Data;Data;Data;Data;Data
Data;Data;Data;Data;Data;Data


Does that make any sense?