Copy file, rename it with T-1 date and paste it on same folder

Help StudioX
,
1

Hi I am trying to copy one of the existing file and replace the name partially with a T-1 business date, and pasting it at the same location. I wonder how exactly can I do it.

Example: copy “file XYZ 20220316” from folder A–> change copied file name from “file XYZ 20220316” to “file XYZ 20220317” → paste the “file XYZ 20220317” to folder A

2

Hello @Nicholas_Yu

Welcome to UiPath community…!

As per the statement, you are trying to rename the file in folder A. So you can directly use the activity, rename file.

Thanks

3

Hey

you can use the copy file activity
image

and then just rename that copied file
image

Regards

4

Hello @Nicholas_Yu , welcome to UiPath Community
you can use the Copy file activity, where need to provide the file path with its extension (.xlsx,.txt,.xlsb). Also the destination with the name that you need to modify and use the same file extension.
image

5

HI @Nicholas_Yu

Welcome to Community!

You can do like this

  • Use Copy file activity and in the destination use this
"file XYZ "+DateTime.ParseExact(System.Text.RegularExpressions.Regex.Match("OnlyFilename with date.extension","\d+").ToString,"yyyyMMdd",System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).AddDays(1).ToString("yyyyMMdd")+".extension"

image
image1909×302 44.2 KB

Regards
Sudharsan

6

Hi Sudha, I am getting this error " Illegal characters in path." But I believe its the correct approach.

Fyi the file I am trying to copy and rename (+1 day) is an excel file with the following naming “XYZ 2023 01 17” Can you kindly assist me with the destination commend

7

Checkout this expression @Nicholas_Yu

"XYZ "+DateTime.ParseExact(System.Text.RegularExpressions.Regex.Match(Path.GetFileNameWithoutExtension("C:\Users\Foldername\XYZ 2023 01 17.xlsx"),"\d{4}\s\d{2}\s\d{2}").ToString,"yyyy MM dd",System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).AddDays(1).ToString("yyyy MM dd")+".xlsx"

Also can you send full path here?

8

From

My Documents\UiPath testing\file XYZ 20220316.xlsx

9

And the to should be like this right?
You can try this @Nicholas_Yu

"My Documents\UiPath testing\file XYZ "+DateTime.ParseExact(System.Text.RegularExpressions.Regex.Match(Path.GetFileNameWithoutExtension("My Documents\UiPath testing\file XYZ 20220316.xlsx"),"\d+").ToString,"yyyyMMdd",System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).AddDays(1).ToString("yyyyMMdd")+".xlsx"

image

Regards
Sudharsan

10

I am still getting an error, is it possible for you to try name an excel sheet as “AAA BB - CCC BBB - 2023 02 14” and copy it by adding 1 day.

From:
My Documents\UiPath testing\AAA BB - CCC BBB - 2023 02 14.xlsx

11

How many type of file name do you have ? @Nicholas_Yu

file XYZ 20220316.xlsx
AAA BB - CCC BBB - 2023 02 14.xlsx

Any other do you have ?

"My Documents\UiPath testing\AAA BB - CCC BBB - "+DateTime.ParseExact(System.Text.RegularExpressions.Regex.Match(Path.GetFileNameWithoutExtension("My Documents\UiPath testing\AAA BB - CCC BBB - 2023 02 14.xlsx"),"\d.+").ToString,{"yyyyMMdd","yyyy MM dd"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).AddDays(1).ToString("yyyyMMdd")+".xlsx"

image

12

Illegal characters in path

13

Can you share the expression which you used @Nicholas_Yu ?

14

From
<[Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments)]>\UiPath testing\AAA BB - CCC BBB - 2023 02 14.xlsx

To:
“My Documents\UiPath testing\AAA BB - CCC BBB - “+DateTime.ParseExact(System.Text.RegularExpressions.Regex.Match(Path.GetFileNameWithoutExtension(“My Documents\UiPath testing\AAA BB - CCC BBB - 2023 02 14.xlsx”),”\d.+”).ToString,{“yyyyMMdd”,“yyyy MM dd”},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).AddDays(1).ToString(“yyyyMMdd”)+“.xlsx”

15

Try this in from field@Nicholas_Yu

Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments)+"\UiPath testing\AAA BB - CCC BBB - 2023 02 14.xlsx"
16

Illegal characters in path

I dont think it is anything to do with the From field commend, as I selected the file via clicking on the “Browse for file”,
“<[Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments)]>\UiPath testing\AAA BB - CCC BBB - 2023 02 14.xlsx” is generated through the system.

I think the problem is, UiPath isn’t able to recognize where I wanted to paste the file to

17

Can you share screenshot @Nicholas_Yu ?

18

image
image955×321 4.83 KB

image
image

19

Checkout this @Nicholas_Yu

Use the below expression in the Advanced Editor
image

From

string.Format("{0}\AAA BB - CCC BBB - 2023 02 14.xlsx", Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments))

To

string.Format("{0}\AAA BB - CCC BBB - "+DateTime.ParseExact(System.Text.RegularExpressions.Regex.Match(Path.GetFileNameWithoutExtension(string.Format("{0}\AAA BB - CCC BBB - 2023 02 14.xlsx", Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments))),"\d.+").ToString,{"yyyyMMdd","yyyy MM dd"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).AddDays(1).ToString("yyyyMMdd")+".xlsx", Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments))

Regards
Sudharsan

20

it worked thanks