Answered

Rename files using regex in PAD

(1) Share

Report

Posted on by v2

Hi guys,

I have a folder with the following files that are downloaded from a website. After download the files should be renamed to the following.

abc_123cl_20230412_w_get_summary.xls should be renamed to "abc_123cl.xls"

red_venxb123_20230412_w_get_summary.xls should be renamed to "red_venxb123.xls"

ere_123ng_20230412_w_get_summary should be renamed to ere_123ng.xls

Basically "_20230412_w_get_summary" should be removed from the name as this changes with the date.

Appreciate the help.

Thanks

Categories:

Power Automate Desktop

All responses (11)

Answers (1)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @v2

Does that date would be current date or something like that ?
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @v2

You can give a try like this as well using regex

Input file for testing:

Output file after renaming

Hope this helps
v2 16 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Nived,

The date will vary and is based on a date the analysis is done.

thanks
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @v2

If the filename format follows that , then try with regex pattern which i have suggested 🙂

Hope that helps 🙂
v2 16 on at

Like
a
(1)

Report
Copy link

Link copied!

Perfect Nived. Thanks a lot.
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Did it worked?
v2 16 on at

Like
a
(1)

Report
Copy link

Link copied!

yes it did Nived. thanks

Do you mind explaining what the regex characters mean and how you got it to exclude?
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Sure. the regex pattern _\d{8}_w_get_summary checks for string which has underscore then followed by 8 digits then underscore followed by w_get_summary

\d{8} , represent regex pattern that searches for a number with 8 digits.

Hope it helps

Mark it as solution if it resolves your query 🙂
CU02081325-2 on at

Like
a
(1)

Report
Copy link

Link copied!

@Navid Nambiar

I have the same exact issue but I cant view any of your solution screenshots. Can you report please?

Where do you insert the regx expression?
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Try this

_\d{8}_w_get_summary

This helps !