Remove Numbers in Brackets

BadDogTitan · 2019-05-14 09:31

I have thousands of files in the following format:

Filename 1 (A101 8.2 S3)
Filename 2 (A5 9 R14B)
Filename 3 (A45 27 M24)

How would I rename them to:

Filename 1 (S3)
Filename 2 (R14B)
Filename 3 (M24)

I know RegEx is the answer, just can't figure it out.

Thanks.

den4b · 2019-05-14 13:03

The following regular expression should do the job...

Expression: $.*?\b([\w\d]+)$
Replace: ($1)

Sample input:

Filename 1 (A101 8.2 S3)
Filename 2 (A5 9 R14B)
Filename 3 (A45 27 M24)
Filename 5 (TEST)

Output:

Filename 1 (S3)
Filename 2 (R14B)
Filename 3 (M24)
Filename 5 (TEST)

BadDogTitan · 2019-05-24 13:28

Fantastic den4b! On using it, I realize the output would look better without the brackets.

How would I return just the number?

Last edited by BadDogTitan (2019-05-24 13:30)

Stefan · 2019-05-24 13:59

BadDogTitan wrote:

Fantastic den4b! On using it, I realize the output would look better without the brackets.
How would I return just the number?

Try to adjust the "Replace:" statement.

Just play around, it's easy:)

Stefan · 2019-05-28 19:35

Stefan wrote:

BadDogTitan wrote:
Fantastic den4b! On using it, I realize the output would look better without the brackets.
How would I return just the number?

Try to adjust the "Replace:" statement.
Just play around, it's easy:)

And, BadDogTitan, how did it worked out?

BadDogTitan · 2019-06-09 20:05

Sorry, Stefan. Haven't been back for a while. Worked out famously. Also, I found the Regular Expression tool on the website, which is a great help.

den4b Forum

#1 2019-05-14 09:31

Remove Numbers in Brackets

#2 2019-05-14 13:03

Re: Remove Numbers in Brackets

#3 2019-05-24 13:28

Re: Remove Numbers in Brackets

#4 2019-05-24 13:59

Re: Remove Numbers in Brackets

#5 2019-05-28 19:35

Re: Remove Numbers in Brackets

#6 2019-06-09 20:05

Re: Remove Numbers in Brackets

Board footer