I have one file,firstfile= "xxxx/yyyy/myself.txt" in one table and another file secondfile="aaaa/bbbb/cccccc/dddddd/myself.txt"

how do i make comparisions between these two files. They are equal because they are same file, but they have different path.

This is what I have....

firstfile2=Replace([firstfile];"xxxx/yyyy/";" ")

secondfile2=Replace([secondfile];"aaaa/bbbb/cccccc/dddddd/";" ")

now I can compare firstfile2 and secondfile2 because now they will have the same value because both "xxxx/yyyy/" and "aaaa/bbbb/cccccc/dddddd/" have been replaced by " ".

But the problem is the firstfile dosnt always has "xxxx/yyyy/" as the preceding file name. It may be "xxxxxxxx/yyyyy", notice the change of length of the string.

I wanted to do

firstfile2=Replace([firstfile];"%/"," ") ...use a wildcard but it is not working.

Help please.