Unanswered

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

I have the same question (0)

All responses (11)

Answers (1)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi @v2

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

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi @v2

You can give a try like this as well using regex

Input file for testing:

Output file after renaming

Hope this helps

Was this reply helpful? Yes No
v2 16 on at

Like (1)

Report

Hi Nived,

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

thanks

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi @v2

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

Hope that helps 🙂

Was this reply helpful? Yes No
v2 16 on at

Like (1)

Report

Perfect Nived. Thanks a lot.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Did it worked?

Was this reply helpful? Yes No
v2 16 on at

Like (1)

Report

yes it did Nived. thanks

Do you mind explaining what the regex characters mean and how you got it to exclude?

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

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 🙂

Was this reply helpful? Yes No
CU02081325-2 on at

Like (1)

Report

@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?

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Try this

_\d{8}_w_get_summary

This helps !

Was this reply helpful? Yes No