Exporting tab delimited adds extra newline and extra tab characters

Åke's Avatar


29 Mar, 2023 09:25 AM

When exporting transactions using Export Data under File/Export, I chose tab delimited data. I filtered for one specific account and saved the exported file.
The resulting file is tab-delimited but in some kind of reporting format. I was expecting one row per transaction, but instead each transaction is broken into multiple lines. Extra tab characters are also inserted into the file, to create some kind of human readable format.
The heading row is one single line, but every row of is 2 lines with the second line containing data fields not present in the heading.

This was not at all what I expected of a tab-delimited transactions export. Shouldn't this export produce:
1. One line per transaction
2. One row of headers, showing data field name.
3. There should be exactly 1 header name for each data column in the export
4. Each data value should be separated by one single tab character, and no extra tab characters for formatting

E.g. a tab delimited file should look like this

ColA ColB ColC
123 456 456
789 785 111
... ...

and not

ColA ColB
123 456
456 789 785 111
111 ... ...

  1. System closed this discussion on 28 Jun, 2023 09:30 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac