Answered

Remove all letters and leave only numbers

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Is there any way to remove all letters when renaming a file, leaving only the numbers? For example, the file "TEST 56784-74" needs to be renamed "5678474". Is it possible to do that? I know that there is an option to remove text when renaming, but there is not only the "TEST 56784-74" file, there are variations of it, however there will always be a numeric string, which is what I need.

Categories:

Power Automate Desktop

All responses (3)

Answers (1)

Sort by

DamoBird365 8,942 Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

This method might work if you can pass your variable back to PowerAutomate....

https://www.alanps1.io/power-platform/flow/flow-stripping-unwanted-characters-or-special-characters-from-a-string/
Verified answer

ZS440 262 on at

Like
a
(1)

Report
Copy link

Link copied!
hi @Anonymous
How about a flow like this?
# Create a Files folder on your desktop. Folder.GetSpecialFolder SpecialFolder: Folder.SpecialFolder.DesktopDirectory SpecialFolderPath=> SpecialFolderPath Folder.GetFiles Folder: $'''%SpecialFolderPath%\\files''' FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files LOOP FOREACH CurrentItem IN Files Text.Replace Text: CurrentItem.NameWithoutExtension TextToFind: $'''[^0-9]+''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''%''%''' ActivateEscapeSequences: False Result=> Replaced File.Rename Files: CurrentItem NewName: Replaced KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles END
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

apparently it works, thanks. Taking the opportunity, would you tell me what function to put in case you want to remove only Numbers? does "\ d" work?