File re-name incrementally

So I searched the forums for this, but couldn't find an exact match. This problem seems like something Hazel can handle with aplomb, but I can't seem to get it right.
All the files for which I want this workflow end with an identical pattern: FILE_NAME_ETC_Mvxx where xx is an integer from 1 (NOT 01; there is NEVER a leading zero) to, say 100. I want a workflow that will simply increase that integer by 1, so Mv1 becomes Mv2, Mv9 becomes Mv10, Mv99 becomes Mv100, etc.
My desired workflow will be a folder in which these files will be dropped. Then hazel renames the file by increasing the integer at the end by 1 and moving it to another location.
Is this possible? It sounds like it should be. I can do the pattern matching part, but I can't seem to find that part where it will incrementally increase the file name version when the number already exists. Thanks for any help.

You can use the "counter" attribute (#) to do that. Note that you should use that when the file is in its final folder as the counter is tied to the folder it is in.

Mr_Noodle wrote:You can use the "counter" attribute (#) to do that. Note that you should use that when the file is in its final folder as the counter is tied to the folder it is in.

Thanks for the reply. Ok I think I found the counter attribute. Clearly I'm using it wrong, because upon testing with an "Mv1" file, it became Mv12. Any tips?

Are you tacking the counter onto a file that already has a number? If so, do you want to replace that number?

Mr_Noodle wrote:Are you tacking the counter onto a file that already has a number? If so, do you want to replace that number?

Yes. I want to replace the previous number with the new number that incrementally one more. a +1, if you will.

You'll need to use pattern matching for that. Search the help for more details but you'll want a custom attribute to grab the part of the name you want to keep and use that in the Rename action.

Mr_Noodle wrote:You'll need to use pattern matching for that. Search the help for more details but you'll want a custom attribute to grab the part of the name you want to keep and use that in the Rename action.

Thanks. I can get it to recognize the name and perform an action, but it doesn't replace the number with the next one, it just adds and new one to it.

Can you post how your rule looks now?

Mr_Noodle wrote:Can you post how your rule looks now?

https://www.dropbox.com/s/o1f4vpk7puj1yqt/Screen%20Shot%202022-06-09%20at%209.19.56%20AM.png?dl=0

Ok, the issue is that you are not using a custom attribute. You need that to keep the parts of the name you want to keep. The "name" attribute is the whole name, so will, of course, have the previous number. Try using a custom attribute for everything up to that number.

Mr_Noodle wrote:Ok, the issue is that you are not using a custom attribute. You need that to keep the parts of the name you want to keep. The "name" attribute is the whole name, so will, of course, have the previous number. Try using a custom attribute for everything up to that number.

Thanks! Did a custom attribute and now something ever weirder happens.
Here is what I have so far:
General Forumula: https://www.dropbox.com/s/m0kgi2gp8enotlw/Screen%20Shot%202022-06-16%20at%208.52.54%20AM.png?dl=0
Detail 1: https://www.dropbox.com/s/efkvvor8nipzv3r/Screen%20Shot%202022-06-16%20at%208.52.38%20AM.png?dl=0
Detail 2: https://www.dropbox.com/s/rgtnuknimkr5yak/Screen%20Shot%202022-06-16%20at%208.52.26%20AM.png?dl=0

Now what happens is that the current number doesn't increment up, but it gets a NEW number that is seemingly random.
Like, a file name ending in _Mv12 will become _Mv125.

You only want "Match File Name" to include the part you want to keep. The way you have it now, it still has the number from before. You want the part after "Mv" to be outside the custom attribute.

Mr_Noodle wrote:You only want "Match File Name" to include the part you want to keep. The way you have it now, it still has the number from before. You want the part after "Mv" to be outside the custom attribute.

Ok, I've modified it slightly to the custom attribute is just "anything". See here: https://www.dropbox.com/s/djagvv44x7ygc45/Screen%20Shot%202022-06-17%20at%209.07.51%20AM.png?dl=0

and modified the rename. See here:
https://www.dropbox.com/s/yq1q5d1uj4jyk9y/Screen%20Shot%202022-06-17%20at%209.10.35%20AM.png?dl=0

Now what happens is the number changes, but not incrementally necessarily, but doesn't replace it, just tacks it on.

Mr_Noodle wrote:You only want "Match File Name" to include the part you want to keep. The way you have it now, it still has the number from before. You want the part after "Mv" to be outside the custom attribute.

But how do I tell it what I DON'T want? if every file name is different EXCEPT the _Mv part, wouldn't a custom attribute be the "Anything" attribute?

But since all the file names are variable UNTIL the Mv part, how do I tell it that?

Also, I guess I don't understand the "Anything" attribute, unless it's the "Mv" in my pattern that's making this not match.
But since the name is variable EXCEPT the "_Mv" at the end, I don't know how to get it to recognize any file I might throw at it.

Screenshot 1: https://www.dropbox.com/s/vjjm9wsite47ou6/Screen%20Shot%202022-06-18%20at%209.31.05%20AM.png?dl=0

Screenshot 2: https://www.dropbox.com/s/m0r40u7n4mzpm3u/Screen%20Shot%202022-06-18%20at%209.30.34%20AM.png?dl=0