Match string wthin files names

Help
, ,
#1

Hello,
please I need ur help, i have a string “name” i have to check within a list of excel file in a directory if a file contain this string. (do some job) and when there is no match i have to create a new excel file named “name”.

Thank you in advance

#2

@ifranity

Check below for your reference
https://forum.uipath.com/t/tutorial-how-to-check-a-string-is-present-in-excel-sheet-part-1/243696/2

You can place a IF condition and use Create File activity to create the file

Hope this helps you

Thanks

#3

You can just pass “name” to an excel application scope. Make sure to check the ‘create new’ property and it will open the file if it exists, or it will create it if it doesn’t exist

#4

@ifranity

grafik
grafik1088×481 43.2 KB

grafik

readin the files from directory with filtering to xlsx extensions:
Directory.GetFiles(“D:_Workplace\work_projects\UIPath-Projects\uipath_forum\Users\ifranity”, “*.xlsx”)

checking if a filename exists with the SearchTerm in its FileName:
arrFiles.Any(Function (x) Path.GetFileNameWithoutExtension(x).Contains(SearchTerm))

If not exists then create the file as @Dave mentioned

Find starter help here:
ifranity.xaml (5.9 KB)