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

[Steve]

Thanks for that Thomas
I have now sent an example csv file which shows the behaviour I am
trying to describe
- Steve


On 16/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. Re: Incorrect payee assignments during csv import when a
>        payee field ends in semicolon (Thomas Baumgart)
>     2. Re: Séparateur décimal (HGGmail)
>     3. Re: Séparateur décimal (Jack)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 14 Feb 2024 13:15:33 +0100
> From: Thomas Baumgart <thb at net-bembel.de>
> To: KMyMoney Users' mailing list <kmymoney at kde.org>
> Subject: Re: Incorrect payee assignments during csv import when a
> 	payee field ends in semicolon
> Message-ID: <4854260.OV4Wx5bFTl at sy-346-nb>
> Content-Type: text/plain; charset="utf-8"
>
> On Dienstag, 13. Februar 2024 22:16:19 CET Jack via KMyMoney wrote:
>
>> 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 ;"/
> I hope only the ones that contain "happy store ;" as payee but not "abc"
> or is that part of the problem?
>
>> 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.
> The terminal ';' is treated just like any other character as 'a', 'b' or 'c'.
> The $ shows up - as Jack already pointed out - as "end of string" marker. That
> entry might then also start with a caret '^' which identifies "start of string".
> They are used to mark a an exact matching so that ^ABC$ matches "ABC" only and not
> "ABCD" which would be a valid match if the $ was missing in the regular expression.
>
> Such meta characters will be added by KMyMoney if you delete a payee (e.g. "ABC")
> and assign existing transactions to another payee (e.g. "DEF"). In that case,
> the receiving payee may add "^ABC$" as an entry in its list of matching names, so
> that the next time the payee ABC is found in a transaction that transaction will
> be assigned to payee DEF.
>