Please note that the changes I made will process an embedded backslash
as before, for compatibility with previous releases. You have to uncheck
the box "Enable escape character ('\')" to get the new behavior.
Something I discovered while testing this change was that reading a CSV
file into Microsoft Excel and simply writing it out again may clean up
the use of double quotes and backslashes. I don't remember whether I
tested other spreadsheets such as LibreOffice or Apple Pages, but you
could try that if disabling escape character processing in Gnucash isn't
sufficient.
On 11/10/26 10:55 PM, Patrick James via gnucash-user wrote:
Ed,
I've imported CSV over 1000 times, probably closer to 1500-2000. The GnuCash
CSV importer is a bit of a Swiss Army Knife, in that it has many different
tools, and I've used the CSV importer in many different ways.
Based on my experience, you have a character issue, some "special character."
With my imports, it's usually a double quote issue, but it could be a different character
issue. There are various special characters.
As a quick inspection, take a look at the data in the import preview window,
and look toward the bottom. My personal experience is that usually the problem
is revealed toward the bottom, but sometimes there are matching problems (i.e.
multiple character problems that happen in pairs, so the data needs more
careful inspection). Somewhere in the preview data, you should see some
problems.
Another approach, the one I usually use, is to search for a special character.
As suggested above, with my CSV imports, it's usually a double quote issue, so
I just search for double quotes.
Recently Tom Teixeira was experiencing an issue with a backslash before a
double quote, but that was fixed with an options box.
https://github.com/Gnucash/gnucash/commit/f737847af2fda683214dc6435a018621066a8a8d
On 11/10/2026 3:26 PM PST Ed Greenberg <[email protected]> wrote:
I've been trying to import from Charles Schwab brokerage account, but the
CSV importer is saying it can't parse some of the individual fields, though
it doesn't say which.
Has anybody got a working import for Schwab downloads in any of their
formats, CSV, XML or JSON?
Thanks,
Ed Greenberg
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
