Exporting tab delimited adds extra newline and extra tab characters

Åke's Avatar

Åke

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 ... ...

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? 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