Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[nathanchavez]

Is it possible to replace the first X number of characters from a filename?  I can't see how to do that.  I can use find and replace, using the name category, but I'm not sure if I can use variables there.

[zybex]

Sure. You can use the F6 tool or an expression on the [Filename] tag. Can you give an example of a before/after filename?
Also, you want to change the [Name] field or the actual filename on disk?

[nathanchavez]

I found the entire red green show at archive.org.  It's 300 episodes.  But the file names are not done by season, like the reason of my library; for example, S15E13 - 294 The Big Retreat as opposed to S15E13 - The Big Retreat.  The total episode count was added, and I'm trying to rename them without that.  So, I need to erase the three numbered characters from the name field and then use f6 to rename the file.  The file currently on the disk in named using the the total episode count.

[zybex]

If that pattern is valid for all files, this should work:

Code: [Select]

=regex([Name],/#(.+?)\s*-\s*\d+\s*(.+)#/,-1)[R1] - [R2]
You could instead use the "Fill Properties From Filename" tool to fill in the [Season], [Episode] and [Name] fields, then use that info to rename the files. This way you could do a Get Movie&TV Info too.

On the F12 tool, use a rule like:
S[Season]E[Episode] - [] [Name]

[nathanchavez]

That doesn't work.    Using: "=regex([Name],/#(.+?)\s*-\s*\d+\s*(.+)#/,-1)[R1] - [R2]" results in all names now becoming "-".

[zybex]

Then your [Name] field is not in the "S15E13 - 294 The Big Retreat" format.
You can test the expression in an Expression column to avoid changing [Name].

[nathanchavez]

No.  It's slightly different; S15E13 - Ep 294 - The Big Retreat.  I need to get rid of "Ep 294 - ", for example.  I think I was off.

[zybex]

OK, try this then:

Code: [Select]

=regex([Name],/#(.+?)-.+?-(.+)#/,-1)trim([R1]) - trim([R2])

[nathanchavez]

Thanks!  That worked.