remove last character with multi-rename tool

[koekje12]

Dear Forum Members,

I am working on a digital archive pre-ingest, my question is as follows:
How can i remove the '_' that are written at the end of my files?

Current filename:
wico_flyer_03_.txt

Desired filename:
wico_flyer_03.txt

I tried working with the [N] placeholders, but can't figure out how to make them useful for this scenario.
The problem is that there are many, many different filenames that end with a '_', I am looking for an effective, time saving solution.
Would greatly appreciate if you know something to help me out !

[Hacker]

Hi koekje12,

Code: Select all

[N1--2]

HTH
Roman

[koekje12]

Hello Roman,

Thanks for your reply!
My apologies, I haven't been very clear in my question, there are also many files with no '_' at the end of their name.
Now I end up removing their names as well, is there any function to only remove the last character when it is a '_' ?

Appreciate the help!
Kind regards

[Stefan2]

FROM:
wico_flyer_03_.txt
wico_flyer_04.txt

TO:
wico_flyer_03.txt
wico_flyer_04.txt


USE:
- select all files
- press Ctrl+M


in MRT:
Search for: _$
Repalce: <Clear>
[_]E
[x]RegEx


Explanation:
- [_]E == Don't work on the file extension but on the base name only
- [x]RegEx == Enable Regular Expression
- Search for "_" at the end of the string ( "$" == regex Line Boundary: match at end of line)
- Replace with nothing (so remove it)




More:
https://www.ghisler.ch/wiki/index.php/Regular_Expressions
https://regex.sorokin.engineer/en/latest/regular_expressions.html
https://regex.sorokin.engineer/de/latest/regular_expressions.html


 

[Dalai]

This should work:

Search for:

Code: Select all

(.+)_$

Replace with:

Code: Select all

$1

[ ] E
[X] RegEx

2Stefan2:
This will replace all underscores, not just the last one.

[Stefan2]

2Stefan2:
This will replace all underscores, not just the last one.

Thank you, your were right for "_?", but I already had adjusted my mistake (typo) while you were typing



 

[koekje12]

Thanks to both of you, it worked

Are there any resources where one can learn to use these '(.+)_$' commands?

[Dalai]

2koekje12
When the MRT is open press F1 to open the help and look for regular expressions. There's a dedicated page in TC help about it. Also see the resources linked by Stefan2.

[koekje12]

I see, thank you!