Incorrect payee assignments during csv import when a payee field ends in semicolon

[Steve]

Hi Jack

I have attached a short csv file with the contents

01-04-2022,KENT,70.00
02-04-2022,Happy Store;,6000.00
03-04-2022,MITCHELL,70.00
04-04-2022,HILTON,50.00
05-04-2022,KENT,70.00

The Happy Store payee ends with a semicolon
I should have mentioned this happens with a brand new, empty kmm project

I would expect the new ledger to reflect exactly the entries shown above
In fact the ledger shows

01-04-2022,KENT,70.00
02-04-2022,Happy Store;,6000.00
03-04-2022,Happy Store;,70.00
04-04-2022,Happy Store;,50.00
05-04-2022,KENT,70.00

So KENT and Happy Store; are assigned as expected
The entries after Happy Store; are matched to Happy Store;
   -except for KENT which is assigned correctly because it had already
been imported before Happy Store;

Under Payees > Matching I see
one entry for KENT:
     ^KENT$
two entries for Happy Store;
     ^Happy Store
     $

Somehow the terminal ; is interpreted as a second entry $ in the
matching list ...
I ran a test which shows that a $ entry in the matching list matches all
subsequent entries to that payee ...

This happens with v5.1.3

- Steve


On 15/02/2024 01:00, kmymoney-request at kde.org wrote:
> Send KMyMoney mailing list submissions to
> kmymoney at kde.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://mail.kde.org/mailman/listinfo/kmymoney
> or, via email, send a message with subject or body 'help' to
> kmymoney-request at kde.org
>
> You can reach the person managing the list at
> kmymoney-owner at kde.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of KMyMoney digest..."
>
>
> Today's Topics:
>
> 1. Incorrect payee assignments during csv import when a payee
> field ends in semicolon (Steve)
> 2. Re: Incorrect payee assignments during csv import when a
> payee field ends in semicolon (Jack)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 14 Feb 2024 08:14:19 +1300
> From: Steve <vivasteve at gmx.com>
> To: kmymoney at kde.org
> Subject: Incorrect payee assignments during csv import when a payee
> field ends in semicolon
> Message-ID: <207aee07-e312-4c5b-ad9f-34cbc6d9eb2f at gmx.com>
> Content-Type: text/plain; charset="utf-8"; Format="flowed"
>
> A strange issue here ... could be a bug or could be some intended
> functionality?
>
> The process
> - export a csv file of transactions from the bank
> - tidy it up for import to kmm
> - import to kmm using csv importer
>
> If one of the payee entries ends with space then semicolon - eg /"happy
> store ;"/
> - all transactions before /"happy store ;"/ are imported correctly
> - all transactions after /"happy store ;"/are assigned the payee /"happy
> store ;"/
>    -unless a matching transaction was imported before /"happy store ;"
> /then they are imported correctly/
>
> /It seems that the terminal semicolon triggers a "$" entry to be added
> to the list of matching names for the payee /"happy store ;"
> /I'm assuming the "$" means "match all entries/
>
> /Just thought I should point this out ... although it may have been
> pointed out before .../
>
> /- Steve/
> /
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> <http://mail.kde.org/pipermail/kmymoney/attachments/20240214/97e2b4f0/attachment-0001.htm>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 13 Feb 2024 16:16:19 -0500
> From: Jack <ostroffjh at users.sourceforge.net>
> To: kmymoney at kde.org
> Subject: Re: Incorrect payee assignments during csv import when a
> payee field ends in semicolon
> Message-ID: <HLDYEE7O.PLO5PUEB.YT5YV55X at PVNOC7FE.IGDW4YH6.ZCI25UPK>
> Content-Type: text/plain; charset=us-ascii; DelSp=Yes; Format=Flowed
>
> Can you provide a three or four line example csv file, with exactly
> what you expect to happen on import.
>
>> - all transactions before /"happy store ;"/ are imported correctly
>> - all transactions after /"happy store ;"/are assigned the payee
>> /"happy store ;"/
> What payee do you expect "happy store ;" to match to? You talk about
> the lines before and after, but not that one.
>
>> It seems that the terminal semicolon triggers a "$" entry to be added
>> to the list of matching names for the payee "happy store ;"
>> I'm assuming the "$" means "match all entries"
> Why do you think a terminal $ is getting added? The matching uses
> regular expressions, and $ means the end of the line, it is not a wild
> card.
> I am also not aware that importing ever changes the matching entries in
> the Payee list, although I could be wrong here.
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney
>
>
> ------------------------------
>
> End of KMyMoney Digest, Vol 158, Issue 5
> ****************************************
-------------- next part --------------
A non-text attachment was scrubbed...
Name: happy-store.csv
Type: text/csv
Size: 125 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20240216/af6f15b8/attachment.csv>