Store into Txt Line break At End of file

[Emmanuelle__Bustos]

Hi Qlik Devs,

I have a question about command Store into textfile.txt (txt, delimiter is ',')

When we open the textfile.txt (using notepad) created from the Store command it always has a line break at the end i.e: there is a blank row at the end, and this means a problem for our purpose:

Doeas anyone know how to avoid this happens?

[Teresa]

Have you found a resolution for this issue, where a blank row is created at the end of a txt file when storing from Qlik?

[marcus_sommer]

I doubt that this could be adjusted on the Qlik-side because it's a feature of the used export-library. If this really caused an empty record within the target-application it shouldn't be too hard to remove it there.

- Marcus

[Bill_Britt]

Hi,

The only way I know to do this is to use PowerShell to remove it, after the store. You may be able to do it using an external program task.

$text = [IO.File]::ReadAllText("c:\test.txt")
[IO.File]::WriteAllText("c:\test.txt", $text.TrimEnd())