I've been using MMEX to get away from proprietary software and it's been great. However, I've been running into some issues with the filtering. I want to filter the transaction items by the notes column, more specifically I want to exclude a specific keyword e.g. "PayPal". This should bring up all transactions that do not include the term "PayPal" in the notes section. Unfortunately, I don't know how to exclude it. I've used some regex testers, but it doesn't seem to work. I've tried looking for some guides and docs on the filtering specifically, but couldn't find anything.
Hence my question: Are there any filtering guides or docs that I've missed that could explain the filtering function?
Is there any filtering guide/documentation?
Moderator: Renato
-
- New User
- Posts: 1
- Joined: Mon Jan 15, 2024 3:15 am
- Are you a spam bot?: No
-
- MVP User
- Posts: 682
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Is there any filtering guide/documentation?
@whall3y @nstein
Perhaps someone could provide a few examples here, that would certainly help a few other REGEX laymen.
Perhaps someone could provide a few examples here, that would certainly help a few other REGEX laymen.
Renato Forum Administrator
-
- Developer
- Posts: 40
- Joined: Tue Nov 29, 2022 10:31 pm
- Are you a spam bot?: No
Re: Is there any filtering guide/documentation?
There is no specific filtering guide -- in fact, documentation for MMEX is a bit sparse in general. However, you can use standard regex in the Notes filter. Exclusion is a little trickier than inclusion, the regex would look something like:
Use it in the filter dialog by prefixing with the string 'regex:' as in to indicate to MMEX that you are providing a regular expression.
This will exclude transactions which have the string "PayPal" anywhere in the transaction notes. Note that you will still see splits for these transactions if they don't also have the word "PayPal" in the split notes (since splits are considered separately for filtering).
In general:
Code: Select all
^(?!.*PayPal).*$
Code: Select all
regex:^(?!.*PayPal).*$
This will exclude transactions which have the string "PayPal" anywhere in the transaction notes. Note that you will still see splits for these transactions if they don't also have the word "PayPal" in the split notes (since splits are considered separately for filtering).
In general:
- to exclude matches where 'text' appears anywhere in a string use ^(?!.*text).*$
- to exclude matches where 'text' appears at the beginning of the string use ^(?!text).*$
- to exclude matches where 'text' appears at the end of the string use ^(?!.*text$).*
You do not have the required permissions to view the files attached to this post.
-
- MVP User
- Posts: 682
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Is there any filtering guide/documentation?
Thanks @nstein , that should explain how complicated the use of regex is for the normal user.
https://github.com/moneymanagerex/money ... ssues/6469
https://github.com/moneymanagerex/money ... ssues/6469
Renato Forum Administrator
-
- Developer
- Posts: 392
- Joined: Wed Dec 21, 2011 5:58 am
- Are you a spam bot?: No
- Location: China
Re: Is there any filtering guide/documentation?
would we add an explicit NOT filtering?