Rename filename

Help Studio
, ,
1

image
image1064×48 2.31 KB

image

Hi Team

i have one file in D:\workbook, named dynamically due to date. how can i locate it and rename it?

Thank you

2

@wason_ha i assume that date is date structured format so it save that file with file name and add current date .if yes
“YOURfileName”+now.ToString(“yyyy-MM-dd”)+“.xlsx”
image
this will help you to locate you file
cheers Happy Automation

3

@wason_ha here its working
before file name
image
pass this in input parameter

The image shows the UI of the Expression Editor in UiPath, with a code snippet to rename a file by appending the current date in 'yyyy-MM-dd' format to its name. (Captioned by AI)
The image shows the UI of the Expression Editor in UiPath, with a code snippet to rename a file by appending the current date in 'yyyy-MM-dd' format to its name. (Captioned by AI)807×338 15.3 KB

(upload://bZVuVuhKoKBS94ENeOyZPy3BZx5.png)

image

and finally output (update name)

The image shows a software interface for renaming a file, with an active output indicating the execution of the "CompareTwoSheets" process alongside file path and email details. (Captioned by AI)
The image shows a software interface for renaming a file, with an active output indicating the execution of the "CompareTwoSheets" process alongside file path and email details. (Captioned by AI)1125×416 22.1 KB

image

cheers Happy Automation

1 Like
4

Hi @wason_ha

"D:\workbook\Report" + DateTime.Now.ToString("yyyy-MM-dd")+".xlsx"

The image shows a file renaming utility where a file at "D:orkbookeport" is renamed to include the current date in the format "yyyy-MM-dd" with the ".xlsx" extension retained. (Captioned by AI)

Hope it helps!!

1 Like
5
  • For Each File in Folder
    – Move File

You can rename with the Move File activity, you don’t have to rename then move.

1 Like
6

Thank you for all the details. it works.

1 Like
7

it works. Thank you Pravallika.

8

image
image740×80 2.9 KB

Hi Pravallika, one more question please. how to locate these 2 types.

Thank you

9

image
Hi Singh, one more question please, how to locate these 2 types?

Thank you

10

Just use the Move File activity and in the destination property give it the full path and new filename.

11

Hi Paul，

when file name is dynamic due to number or date suffixes. how can i use the file path?

Thank you

12

Hie @wason_ha i’m assuming this is your table name -like this
“Vizlib Pivot Table - +now.tostring(“yyyy_M_d”)+“5T”+Now.tostring(“HH-mm-ss”)+” - BASED BMS").
Try this
and your previous query is resolve and this is your new query so please make a new query and post it so it help other too. if they stuck and search for this kind of query . because you open new query inside the solved query
cheers Happy Automation.

13

With For Each File in Folder

1 Like
14

Got it. Thank you for the analysis and solution!

1 Like
15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.