The powerful, highly-customizable categorization-engine AutoCat is one of the features that makes Tiller unique. Many users have built filters using familiar criteria like Contains. More advanced users have experimented with filters like Starts With, Ends With or Max and Min. But the Regex filter…

Got it, will do. That seems to work for when you’re looking for a match but what about for the renaming of a given column… let’s say for example if I wanted to always strip away: “[Amazon Item]” from the imported transactions’ Descriptions… like here: [image] I guess I’m ultimately asking if Reg…

Are you asking if the output rule can incorporate dynamic data from a transaction it is modifying? Unfortunately, that is not possible at this time, @diogo6 .

Yep, that’s what I was asking and “too bad, but ok, that’s what I’d thought.” If you can add that to your long to do list, it’d be great :slight_smile:

Alternative way to match two strings in any order (as AND logical operator). foo.*bar|bar.*foo I use it, for example, to categorize something under Subscriptions when it contains the name of the service AND the word “recurring”.

[image] mk1: foo.*bar|bar.*foo I would like to use this regex but make it case insensitive, so I can match with merchants that mix up their capitalization in a transaction description. For example, the regex would match Foo bar and Foo Bar. If I do the regex (?i)foo.*bar|bar.*foo inside the =…

[image] keith: but I get an error when I try it with AutoCat What is the error message? Also a note from the original post: [image] randy: Notes Tiller’s regex filter criteria are case insensitive.

Error with (?i) added is: Regex failed: "Invalid regular expression: /(?i)foo.* bar|bar.*foo/: Invalid group" Doing foo.* bar|bar.*foo without (?i) does not match case insensitive for two terms. It just says no transactions found.

I’m curious what happens if the whole regex string is grouped? (foo.* bar|bar.*foo) The examples I’ve seen do that and that’s the way I’ve been doing it when using the | operator.

I have tested this, and the original regex is case-insensitive and should work as is.

Yeah, same with my testing. case-insensitive, no grouping needed.

What Is Your Favorite AutoCat Regex?

Conversation

Mark.S March 15, 2024, 9:19pm 23

What is the error message?

Also a note from the original post:

Autocat Contains Search Terms

Topic		Replies	Views
Using RegEx with AutoCat Google Sheets how-to , autocat	31	3235	December 12, 2023
AutoCat simple(?) regex not working Google Sheets autocat	8	730	January 11, 2022
Using AutoCat and Regex Conversation autocat , regex	2	1305	October 1, 2022
Autocat Contains Search Terms Google Sheets autocat	21	1387	September 10, 2024
Introducing AutoKitten, an alternative to AutoCat gSheets Templates google-sheets , scripts	54	2234	August 4, 2026

What Is Your Favorite AutoCat Regex?

Related topics