struggling with Match Regex in Reconciliation Models

Question

I have written what I think is a very simple regex pattern for matching transactions from my bank feed, but it's not working as expected.
this is the regex for the Label:
PARKING|TRANSPORT|SCENTRE|PARK|TOLL the intention is to find any transaction that has any of these words in it
parking transport scentre Park  toll  this is working for quite a few transactions, however I have a transaction with this label:
THE SPOT WILSON PARKING  RANDWICK CREDIT CARD PURCHASE
and for some reason it's not matc

Lance Nurick · Accepted Answer

I resolved this by creating a regex that matches the entire string, not just part of the string:
^.*(some string|some other string|patternX|patternY).*$

Related Posts	Replies	Views
Possible to use Reconciliation Models for other accounts? accounting reconciliation	0 Oct 24	1528
Open amounts in reconciliation in Accounting App accounting reconciliation	0 Oct 23	2121
Accounting Reconciliation- Solved accounting reconciliation	5 Jun 23	4726
Nominal account reconciliation accounting reconciliation	0 Nov 22	1921
How to show only reconciled Journal Entries of a Miscellanous Journal ? accounting reconciliation	1 Aug 22	3165

This question has been flagged

Enjoying the discussion? Don't just read, join in!