Answered

How to replace numeric part of file name using regex

(1) Share

Report

Posted on by franco2

I would gladly appreciate if someone could help me using regex correctly in power automate desktop.

I'm using the replace File Name function with ([0-9]+) regular expression. I have also tried \d+ and [0-9]+ but it does not seem to work. I don't know if regex syntax in power automate is used differently.

My objective is to:

file_name_9875234.csv ----> file_name_%currentDate%.csv

Categories:

Power Automate Desktop

All responses (4)

Answers (1)

Sort by

Verified answer

UshaJyothiKasibhotla 229 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

HI @franco2

Please try as shown below image

It worked for me if you have any doubt please let me know

the code is below please paste into your PAD Designer

SET STR TO $'''file_name_9875234.csv'''
DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateOnly CurrentDateTime=> CurrentDateTime
Text.Replace Text: STR TextToFind: $'''\\d+''' IsRegEx: True IgnoreCase: False ReplaceWith: CurrentDateTime ActivateEscapeSequences: False Result=> Replaced

Hope this helps,

Usha.
franco2 33 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you! it did work, now I'm gonna modify my code to integrate the solution.
UshaJyothiKasibhotla 229 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

If it works please mark it as a solution to close the loop
franco2 33 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, new to this.
Thank you