Unanswered

Remove all letters and leave only numbers

(0) Share

Report

Posted on by Community Power Pla...

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

I have the same question (0)

All responses (3)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

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/

Was this reply helpful? Yes No
Verified answer

ZS440 262 on at

Like (1)

Report
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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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?

Was this reply helpful? Yes No