Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How can I remove the last empty row from a created txt with tfileoutputdelimited?

I have this job,

tDBinputmysql - main - tflowtolterate - tfixedflowinput - tfileoutputdelimited 

where a txt file is generated, I need to delete the last empty row that is generated in the txt. It is not a data source problem.

Your help please

Labels (3)
4 Replies
manodwhb
Champion II
Champion II

@aulloa , if it is not source problem how the empty line is creating?

Anonymous
Not applicable
Author

It is created when generating the txt with tfileoutputdelimeted, at the time of the last line break. All I want is to delete the last line break from the file, I tried with tfileoutputfullrow -main - tfileoutputdelimited but I couldn't.

TRF
Champion II
Champion II

As soon as every record terminales with \n this is normal to see an empty Line at the end.
You need a piece of code to remove the last file character if needed.
Michele3
Contributor
Contributor

Hello @Arturo Ulloa​, did you manage to remove the last empy row in the txt, at the end? If yes, how?

Because I am facing the same problem 🙂