Write range file name

[JeffNZ (Jeff)]

Hi,

I tried to specify the following as the file path in write range activity:

“Ui Path\Self-Serve Files\Self-Serve File “+Date.Now.ToString(“dd/MM/yy”)+”.xlsx”

What I am trying to achieve is to save a file called “Self-Serve File 04/04/19”. I’ve found that with the above setup UiPath creates 2 further sub folders (“Self-Serve 04” and “04”) and saves a file called “19.xlsx” in the “04” sub folder.

How can I ensure that a file called “Self-Serve File 04/04/19” will be saved in the “Self-Serve File” sub folder?

Many thanks in advance,

Jeff

[DiegoTurati]

Hi @JeffNZ, how are you? Could you check this post below :

Saving text files to drive with different names

Hi, I am trying to save text files with different names in a folder. i am using a type into activity with the below expression - “File.Create(“C:\Users\rsugesh\Desktop"+row(0).ToString+”_”+DateTime.Now.Date.ToString(“dd-MM-yyyy”)" can someone help me correcting this expression?

In order to ensure, you need to use File.Exists :

How to read a text file's name?

Hello. It might be easier to help if you showed a snippet of your workflow, like a screenshot. But here are some tips that will help. Let’s assuming you use .GetFiles() or .GetEnumerateFiles() So, then, you can check the filename using Path.GetFilename or Path.GetFilenameWithoutExtension It would look like this: For each file In Directory.GetFiles(foldername, "*.txt") If activity: condition: Path.GetFilenameWithoutExtension(file).ToLower.Equals("abc") <perform actions> Note: Y…

Check and let me know if you was able to solve your problem.

~Diego Turati

[ClaytonM]

I noticed you are formatting your date with slashes, which are not applicable characters for a filename.

You will want to use a different character than the slash, like a dot or dash.
Now.ToString("dd-MM-yy")

Additionally, I normally recommend to put the year then month first, so when you sort the files, it sorts correctly. - unless the folder only has items for that year or month.
For example, Now.ToString("yyyy-MM-dd")
which will sort the files by year then by month when sorting alphabetically. This is optional though, and like I said depends on if the files are all in a folder for only that year or month or not. - This is also a manual process recommendation, so not specific toward robots.

Regards.

[JeffNZ (Jeff)]

Hi Clayton,

Thanks for this. That solved my problem! I changed to dots and now my files are being saved in the intended folder.

Regards,

Jeff