Rename File in folder

[mohan2mm]

Hello All - I have a requirement to rename the file in the One drive. Every month client send us the file which is suffixed with month and year in below formats,

Ex -

1.  backup_Feb-24.xlsx 

2. Summary_Feb-24.xlsx

3. Invoice-Feb24.xlsx

4. Data_Febrauary-2024.xlsx

We receive plenty of files in different format but I have a list of standard naming convention for each file, The above file name consist part of standard naming convention as below

1.  backup.xlsx 

2. Summary\.xlsx

3. Invoice.xlsx

4. Data.xlsx

What are the possible solutions to achieve this requirement. 

[Deenuji]

@mohan2mm 

Here's what you need to do:

1. Begin by defining all the suffix details in the list.For example: _Feb or -Feb or #Feb or any suffix details in the list.

2. Then, configure your folder path as indicated below, and apply the necessary file filter.

3. Finally, you can use the file rename action to remove all suffix details by replacing them with an empty string.

Code:

SET Suffix_list TO ['_Feb-24', '_Febrauary-2024']
Folder.GetFiles Folder: $'''C:\\Users\\OneDrive \\Excel File''' FileFilter: $'''*xlsx''' 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 Current_File_Path IN Files
LOOP FOREACH Suffix_item IN Suffix_list
File.RenameFiles.RenameReplaceText Files: Current_File_Path TextToReplace: Suffix_item IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles
END
END

-------------------------------------------------------------------------------------------------------------------

If I've resolved your query, please consider accepting it as the solution and giving it a thumbs up to help others find answers faster.

[SandhiyaDurga]

Hi @mohan2mm 

Please find the below solution,

Step1: Get all files in the Folder.

Step2: Loop through each file and using Crop text, remove from "_" till "."

Step3: Rename file with croppedText output value and extension.

If I've resolved your query, please consider accepting it as the solution and giving it a thumbs up to help others find answers faster.

Thank you,
Sandhiya P

[mohan2mm]

Hello Deenuji - Thanks for your response.

The file names in the folder are inconsistent Ex - File_Dec-23, File1-Dec-23, File2Dec-23.

So there is no constant character to loop and rename.

However I have the list of file names i.e File, File1 and File2, I there a possibility I do wild search and the closest one I rename with standard name.

[Deenuji]

@mohan2mm 

Try if this make sense to you(without any scripting language).

Begin by listing all your file names in the list variable. Next, we will utilize text parsing to verify whether the file names mentioned in the list exist within the file name. If they do, we will then proceed to rename the file by removing all additional characters and retaining only the file name.

Code:

SET File_list TO ['backup', 'Summary', 'Invoice', 'Data']
Folder.GetFiles Folder: $'''C:\\Users\\OneDrive - office365journey\\Excel File''' FileFilter: $'''*xlsx''' 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 Current_File_Path IN Files
LOOP FOREACH File_item IN File_list
Text.ParseText.ParseForFirstOccurrence Text: Current_File_Path.Name TextToFind: File_item StartingPosition: 0 IgnoreCase: True OccurrencePosition=> Position
IF Position = 0 THEN
File.RenameFiles.Rename Files: Current_File_Path NewName: File_item KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles
EXIT LOOP
END
END
END

--------------------------------------------------------------------------------------------------------------------------
If I've resolved your query, please consider accepting it as the solution and giving it a thumbs up to help others find answers faster.

[mohan2mm]

@Deenuji 

I tried a couple of ways but no fruitful result.

I have a folder in the desktop called "abc" in this folder there is an excel file by name "Invoice_test", which I want to rename as "Invoice" using Prase Text.

I have attached the screen shot of the flow, please guide me where i have gone wrong. 

Note - I'm trying with one file currently and this is dummy data after getting sucessful result will go with real time requirement.

I 

[Deenuji]

@mohan2mm 
The below code working fine for me. In case if you facing any issues please share some screenshot of error.

SET File_list TO ['Invoice']
Folder.GetFiles Folder: $'''C:\\Users\\OneDrive\\Demo\\abc''' FileFilter: $'''*xlsx''' 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 Current_File_Path IN Files
    LOOP FOREACH File_item IN File_list
        Text.ParseText.ParseForFirstOccurrence Text: Current_File_Path.Name TextToFind: File_item StartingPosition: 0 IgnoreCase: True OccurrencePosition=> Position
        IF Position = 0 THEN
            File.RenameFiles.Rename Files: Current_File_Path NewName: File_item KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles
            EXIT LOOP
        END
    END
END

[mohan2mm]

@Deenuji - There is no as such error, the Flow is getting executed but the file names is not getting renamed.

Is there a way i can copy your code and paste it into my flow to resolve this issue ?

[Agnius]

The reason why you are not getting the expected result is the fact that both of your loops are iterating through the same collection - the list of files. While in the actual recommended scenario, your inner loop should be iterating through the list of keywords, and not files.

And yes, you can copy the code @Deenuji provided and paste it directly into your PAD designer - the actions will be created for you automatically.

[Deenuji]

@Agnius Welcome back ❤️💐

@mohan2mm:

Please check the below image and replace your second loop file with file_list.

As @Agnius mentioned, you copy my code like below and paste into you PAD designer.

Thanks,
Deenuji Loganathan
🤖 Automation Evangelist
Deenuji - Follow me on LinkedIn

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟

[mohan2mm]

This is awesome, it started working and appreciate the explanation.

I have other challenge with few files, where the actual file names are as below

"Availability Details - Oct 2023_Bronze"

"Availability Details - Oct 2023_Gold"

want to rename them as 

"Availability Details_Bronze"

"Availability Details_Gold"

[mohan2mm]

@Agnius - Thanks it worked.

[Agnius]

You would need to use Replace text on the file name with some regular expressions (assuming the month and the year are not static. The safest way to do that would be going with (\s-.+_) as the regex - this would match everything between - and _. And you can replace it with an _ character.

You can then use the outputs of this action in a Rename file(s) action to rename the file with the new name after replacing the text.

[mohan2mm]

@Agnius Confirm if my understanding is right. the logic here, you are trying to find "\s -.+_" in the file name and replace the identified characters with "_".

This should ideally work but I'm not getting the way to accommodate these in flow, please do suggest where this needs to be used in the flow. 

SET File_list TO ['12.1_MNS Standard Voice -- Critical Voice Site Availability', '12.2_MNS Standard Voice -- Standard Voice Site Availability', '14.12_Privileged_Account_Management_Availability', 'Server Availability by Category of Server - Bronze - Dev', 'SLA 8.6 Server App availability', 'Apps Availability Details_Bronze']
Folder.GetFiles Folder: $'''C:\\Users\\mohanr\\OneDrive - Information Services Group (ISG)\\Desktop\\abc''' FileFilter: $'''*xlsx''' 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 Current_File_Path IN Files
LOOP FOREACH File_item IN File_list
Text.ParseText.ParseForFirstOccurrence Text: Current_File_Path.Name TextToFind: File_item StartingPosition: 0 IgnoreCase: True OccurrencePosition=> Position
Text.Replace Text: Current_File_Path.NameWithoutExtension TextToFind: $'''(\\s -.+_)''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''_''' ActivateEscapeSequences: False Result=> Replaced
IF Position = 0 THEN
File.RenameFiles.Rename Files: Current_File_Path NewName: File_item KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles
File.RenameFiles.Rename Files: Current_File_Path NewName: Replaced KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles
EXIT LOOP
END
END
END

[Deenuji · Accepted solution]

@mohan2mm 

Upon reviewing your code, I noticed that you've listed some file names in your file list. However, I suggest including suffixes in that list, which are the text portions to be removed from your existing file names. For instance, you can include items like "-Oct 2023" or "-Apr_2024," etc.

If do so, it will work for use case.

Thanks,
Deenuji Loganathan
🤖 Automation Evangelist
Deenuji - Follow me on LinkedIn

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟