I have created a report that needs to run daily in CSV format and email into our parent company's automated system. The report works perfectly, and I can schedule it as required, but the automated system I am sending it to requires the output file to have a ".txt" extension, not a ".csv" extension. I have tried including ".txt" in the file name in the scheduler's output options, but the resulting csv output file is then "<filename>.txt.csv". This will not work and I have to solve it. how can I do this?
Seems like you going to have add some custom code. Don't think there is a easier way that you going to achieve your desired results.
So maybe have a look if the below link might asssit.
or you might need to dump the csv file somewhere and then add the txt ext with some cusotm code.