Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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?
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
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())