How to: xxx-nnyy.zzz -> xx0xyy.dnn ?

[pm771]

What is the easyest way to rename a group of files following the same pattern like the one in the subject?

The result name in this example will be:

Code: Select all

SUBSTR(cNameOrig,1,2) + "0" + SUBSTR(cNameOrig,3,1) + SUBSTR(cNameOrig,7,2) + ".d" + SUBSTR(cNameOrig,4,2)

I'm not too familiar with regular expressions. Do I need to learn them or is it a better way?

TIA, Eugene

[Admin]

without question, this will be very straightforward using a regular expression.

[pm771]

I could not figured out how to change the file extension using regular expressions.

Also, if I need to pad a number with zeroes, how do I do it?

For examle, I need the same expression to make the following renamings:

A1.TXT -> A.001
A12.TXT ->A.012
A123.TXT -> A.123

Could you please clarify the above?

TIA, Eugene

[GMA]

Hi, Eugene:
First of all, go to "Options > Ignore" and check "File Extensions". Then you're gonna need to do three passes, one for each kind of padding (I don't think there's any way to do it just in one). Use the following regular expressions:

For "Ax.TXT" > "A.00x":
MATCH: ([A-Z])([0-9])(.TXT)
REPLACE: \1.00\2

For "Axx.TXT" > "A.0xx":
MATCH: ([A-Z])([0-9]{2})(.TXT)
REPLACE: \1.0\2

For "Axxx.TXT" > "A.xxx":
MATCH: ([A-Z])([0-9]{3})(.TXT)
REPLACE: \1.\2

Of course, this was based strictly on your examples (it'll work for "A[x, xx or xxx].TXT" to "Z[x, xx or xxx].TXT"). But you might need to modify something if your filenames aren't exactly as you described them.
Best regards,

Gabriel.

[pm771]

Gabriel,

Thank you very much for pointing me in the right direction.

One more question, if I may. When I need to match "." (period character) should I use "\."?

Eugene

[GMA]

That's right