cancel
Showing results for 
Search instead for 
Did you mean: 

Renaming from collection

newblueprism
Level 3
I have downloaded few files save in folder. The daily download file name are dynamic. How can I rename all this file name from collection? Or any other better solution?
28435.png


------------------------------
new blueprism
------------------------------
4 REPLIES 4

GopalBhaire
Level 10
Loop over the collection and use move from File Management VBO to same folder with new name.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

All files in collection will have a different name. Example as below:

FileABC_12345.xlsx rename to FileABC_reportA.xlsx
FileABC_56789.xlsx rename to FileABC_reportB.xlsx
FileABC_98765.xlsx rename to FileABC_reportC.xlsx

And so on. Is that possible?

------------------------------
new blueprism
------------------------------

Yes, You can loop and use move file with FilePath coming from Files collection and destination path something like where count is integer  but you can write a similar logic for A, B, C etc
[Files.Folder]&"\"&Left([Files.Name],InStr([Files.Name], "_"))&"report"&[count]&[Files.Extension]​


------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

Thanks. Is working.

------------------------------
new blueprism
------------------------------