How to find a specific file with specific name?

[Lynx (Lnx)]

Good evening friends, a question please

I need to find the file with last date and containing (TR):

JVL Report - Week 10, 04.03.2024 (TR).xlsb
JVL Report - Week 10, 06.03.2024 (TR).xlsb
JVL Report - Week 10, 04.03.2024.xlsb
JVL Report - Week 10, 06.03.2024.xlsb

I have been trying with :

“Directory.GetFiles(path_file, ).Where(Function(w)(Path.GetFileNameWithoutExtension(w).ToLower.Contains(“TR”))).ToArray()”

But something is not working for me

Thank you very much in advance

[lrtetala (Lakshman Reddy)]

Hi @Lynx

Try this

latestFile = Directory.GetFiles(path_file).Where(Function(file) Path.GetFileNameWithoutExtension(file).ToLower.Contains("(tr)")) _
               .OrderByDescending(Function(file) DateTime.ParseExact(file.Substring(file.IndexOf(",") + 2, 10), "dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture)) _
               .FirstOrDefault()

Regards,

[Parvathy (PS Parvathy)]

Hi @Lynx

Try this:

latestFile = Directory.GetFiles(path_file).Where(Function(w) Path.GetFileNameWithoutExtension(w).ToLower.Contains("(tr)")).OrderByDescending(Function(f) DateTime.ParseExact(System.Text.RegularExpressions.Regex.Match(Path.GetFileNameWithoutExtension(f), "\d{2}\.\d{2}\.\d{4}").Value, "dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture)).FirstOrDefault()

Hope it helps!!

[Parvathy (PS Parvathy)]

Hi @Lynx

Input:

latestFile = Directory.GetFiles(path_file).Where(Function(w) Path.GetFileNameWithoutExtension(w).ToLower.Contains("(tr)")).OrderByDescending(Function(f) DateTime.ParseExact(System.Text.RegularExpressions.Regex.Match(Path.GetFileNameWithoutExtension(f), "\d{2}\.\d{2}\.\d{4}").Value, "dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture)).FirstOrDefault()

Output:

Hope it helps!!

[Lynx (Lnx)]

Thank you so much Parvathy!

[Parvathy (PS Parvathy)]

You’re welcome @Lynx

Happy Automation!!

[Lynx (Lnx)]

It works perfectly, thanks a lot!