topic Re: How can I remove the last empty row from a created txt with tfileoutputdelimited? in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 02:30:06 GMT

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

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

manodwhb — Thu, 07 May 2020 05:02:48 GMT

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

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

Anonymous — Thu, 07 May 2020 13:36:30 GMT

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.

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

TRF — Fri, 08 May 2020 06:35:55 GMT

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.

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

Michele3 — Mon, 07 Jun 2021 14:22:52 GMT

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 🙂