I need help with this Excel Workflow

[sureshj (suresh_hserus)]

@B.D

For Getting latest file kindly refer this,

Find latest File in a folder with respect to date Created

I have written a code to find the most recent file in a directory, it finds the most recent file as per the last modified date. The logic for the same is as follows: Create an array of datatype File info and save the names of files present in the required directory in descending order with respect to their last modified date. The code for the same is as follow: last_mod_files = directory.GetFiles("*AHS Roster.xlsx").Where(function(file) file.LastWriteTime.Date= DateTime.Now.Date).OrderByDesce…

And for the 3 letters, you can use the Substring method which will help you.

How to use the trim, split, substring, remove

Hi All: I’m a beginner for UiPath. When I searched “how to remove a part of string”, there were lots of ways to achieve the result I found. Trim, slip, substring, remove,replace, etc. Actually, I know none of them. So could you please tell me how to use them or where I can find the introduction for them. Thanks in advanced !

Thanks,
Suresh J