Exporting tab delimited adds extra newline and extra tab characters
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
456 789 785 111
111 ... ...
|?||Show this help|
|ESC||Blurs the current field|
|r||Focus the comment reply box|
|^ + ↩||Submit the comment|
You can use
Command ⌘ instead of
Control ^ on Mac