How to read a text files with today's date in folder

[Bhavya_Amala_Kosana]

Hi all,

Can you all please how to a read text file which has today’s date only and not other files which gets added everyday. how to write an expression so that it can open , files according to date.

[Bhavya_Amala_Kosana]

I have tried writing it like this but its not working. Please do help me out

Thanks in advance

[prasath17 (Guru)]

@Bhavya_Amala_Kosana - could you please show the screenshot of the file name ?

Please check this post …

How to use click activity to select a particular file from a folder

Here you go: [image] Here is my files in the folder… [image] Code: StrGetTodayFileName = Path.GetFileName(Directory.GetFiles(“Test\ZippedFiles\Green",”*.zip").OrderByDescending(Function(d) New FileInfo(d).LastWriteTime).First) Here StrGetTodayFileName is of type string… Hope this helps…

[NIVED_NAMBIAR (NIVED N)]

Did u mean u need to open the file having today’s date as creation date or file having today’s date as filename ?

[Bhavya_Amala_Kosana]

file having today’s date as filename

[vignesh.ks]

Hi @Bhavya_Amala_Kosana

Can you please give a example name of the text file. So that we can design the code.

Thanks.

[Bhavya_Amala_Kosana]

the file name is as follows cadence_18032021, cadence_19032021, cadence_20032021. i want my code to open and read only the file with today’s date

[prasath17 (Guru)]

Hi @Bhavya_Amala_Kosana - please try like this

StrFiles = Directory.GetFiles(“yourpath”,“cadence_”+Now.date.ToString(“ddMMyyyy”)+“*.txt”)

[vignesh.ks]

Please find the below screen shots for your reference.

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

[NIVED_NAMBIAR (NIVED N)]

Hi @Bhavya_Amala_Kosana

The best way would we to filter the files in the folder by the given condition and then read the list of text files which satisfies that

Check this workflowTesttn.zip (50.4 KB)

Hope it helps you

Regards,

Nived N
Happy Automation

[Yameso (Jakub Swiderski)]

It should be array of files. If there is only one file name for day then it should look like this:

StrFiles = Directory.GetFiles(“yourpath”,“cadence_”+Now.date.ToString(“ddMMyyyy”)+“*.txt”)(0).toString

If there is more files with today date then 1:

arr_strFiles = Directory.GetFiles(“yourpath”,“cadence_”+Now.date.ToString(“ddMMyyyy”)+“*.txt”)

And in for each item in arr_strFiles we can open the file

[Bhavya_Amala_Kosana]

Thank you

[Bhavya_Amala_Kosana]

Thank you all for helping me. I got it.