csv export invalid with semicolon in text

Bug #1967708 reported by Lindsay Lorden
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
HomeBank
Fix Released
Low
Maxime DOYEN

Bug Description

The CSV character choice in Preferences only affects importing of transactions. When exporting, it always uses a semi-colon.
Can the character chosen in Preferences be used when exporting, or optionally a second Preference (happy for current default of ; to be set) for export delimiter?
Reason being I had a semicolon in the Memo field and it threw the CSV importing out(!). I use export when in 'Transactions \ Show All' (and sometimes 'Show').

A related nice feature would be to warn user if the CSV character is included in any data field - so they can correct (= remove) it before saving the change, unless they explicitly then "OK" it anyway.

Operating System: Windows 10 & 11
HomeBank 5.5.4
Running against GTK+ 3.24.31

description: updated
description: updated
Maxime DOYEN (mdoyen)
Changed in homebank:
assignee: nobody → Maxime DOYEN (mdoyen)
importance: Undecided → Low
status: New → Confirmed
Maxime DOYEN (mdoyen)
Changed in homebank:
importance: Low → Wishlist
milestone: none → 5.6
Maxime DOYEN (mdoyen)
Changed in homebank:
status: Confirmed → In Progress
Revision history for this message
Maxime DOYEN (mdoyen) wrote :

the problem is not really the delimiter, it is just that I do not use string delimiter " when the text as the separator into it, for example, if you import this, it will work

date;paymode;info;payee;memo;amount;category;tags
05/18/2022;0;;;"memo with ;";0,00;;"tag;"

but anyway, choosing the export separator by default and at export time is a plus

Revision history for this message
Lindsay Lorden (ludwigwn) wrote :

Will you include the string delimiter " with this update?

Revision history for this message
Maxime DOYEN (mdoyen) wrote :

yes it is committed into 5.6
maybe I will include also into 5.5.6

Maxime DOYEN (mdoyen)
summary: - wish: user setting for export csv delimiter character
+ csv export invalid with semicolon in text
Changed in homebank:
importance: Wishlist → Low
milestone: 5.6 → 5.5.6
status: In Progress → Fix Committed
Maxime DOYEN (mdoyen)
Changed in homebank:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.