topic RE: Renaming from collection in Product Forum

Renaming from collection

newblueprism — Fri, 15 May 2020 03:19:00 GMT

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?

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

RE: Renaming from collection

GopalBhaire — Fri, 15 May 2020 04:26:00 GMT

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

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

RE: Renaming from collection

newblueprism — Fri, 15 May 2020 04:36:00 GMT

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
------------------------------

RE: Renaming from collection

GopalBhaire — Fri, 15 May 2020 07:15:00 GMT

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
------------------------------

RE: Renaming from collection

newblueprism — Sun, 17 May 2020 14:03:00 GMT

Thanks. Is working.

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