If activity comparing file path

[omar_ismail]

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.

[vrdabberu (Varunraj Dabberu)]

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

[omar_ismail]

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.

[vrdabberu (Varunraj Dabberu)]

Hi @omar_ismail

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

Regards

[lrtetala (Lakshman Reddy)]

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

[omar_ismail]

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

[raja.arslankhan (Raja Muhammad Arslan khan)]

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

[lrtetala (Lakshman Reddy)]

@omar_ismail
Give current file it will print total path