Looking For File With A Specific Naming Convention EveryDay

Help Activities
, ,
11

You can directly use this LINQ expression in the condition of the ‘If’ activity:

Directory.GetFiles("\epic-nas.et1157.epichosted.com\xfr\nonprd\toODB\Claims\PBClaims\CRD\TEST1\archive\").Any(Function(file) Path.GetFileName(file.ToString).StartsWith("EPICTRAN_" + Today.ToString("yyyyMMdd")) AndAlso Path.GetExtension(file.ToString).Contains("txt"))

This LINQ retrieves all files in the specified path and checks if any of them start with the desired naming format while ensuring the file extension is .txt. It returns a boolean, making it suitable for use directly in the condition part of the ‘If’ activity.

For example:

Directory.GetFiles([YOUR_FOLDER_PATH]).Any(Function(file) Path.GetFileName(file.ToString).StartsWith([FIXED_PART_OF_THE_NAME]) AndAlso Path.GetExtension(file.ToString).Contains([EXTENSION]))

Here’s a screenshot of a found case:

This image shows a screenshot of UiPath Studio in debug mode with a conditional workflow that checks for the existence of a specific file and logs messages accordingly. (Captioned by AI)
This image shows a screenshot of UiPath Studio in debug mode with a conditional workflow that checks for the existence of a specific file and logs messages accordingly. (Captioned by AI)1918×1016 84.5 KB

Not found case:

This image shows a debugging session in UiPath Studio with an IF activity, where log messages "Found" and "Not" are used based on a condition checking for files in a directory. (Captioned by AI)
This image shows a debugging session in UiPath Studio with an IF activity, where log messages "Found" and "Not" are used based on a condition checking for files in a directory. (Captioned by AI)1918×1015 83.8 KB