If activity comparing file path

Help Activities
, ,
1

Hi Guys

in the below screen, readname variable refer to a cell containing the file path so i need the BOT after reading the cell to compare the path in Excel and the actual path in the “for each folder in folder” activity file path and not to take it.

image
image1161×845 38.8 KB

2

Hi @omar_ismail

Here you have been comparing the excel data and the actual data but the thing is like you have been comparing the full file path (Readname) with only the file name(Current.Name) so this may fail, even though it’s getting true so please change the CurrentFile.Name to CurrentFile or else change the condition from not equals to contains.

Regards

3

i know this so i am asking if anyone knows the expression that i can use to solve this issue.
or what should write instead of Current name.

4

Hi @omar_ismail

Change the CurrentFile.Name to CurrentFile or else change the condition from not equals to contains.

Regards

5

Hi @omar_ismail
Check your Excel path and File name is same or not
Excel cell containing the file path like “C:\Users\Documents…”
Current file name contains your file name
So, Excel cell and Current file doesn’t equal

6

i know this so i am asking for the expression what should i write instead if current file name

7

@omar_ismail Try this in condition
CurrentRow.Tostring.ToUpper.contains(readname.Tostring.ToUpper)

8

@omar_ismail
Give current file it will print total path

image
image1624×826 46.6 KB

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.