Hi there,
I am receiving 5 excel files as an input, but sometimes one or more excel file is/are missing. I need to find out the filename of the missing excel file.
The dummy input file names are given below.
XYZ_ABCD1_filename.xls
XYZ_ABCD2_filename.xls
XYZ_ABCD3_filename.xls
XYZ_ABCD4_filename.xls
XYZ_ABCD5_filename.xls
Note: The XYZ_ABCD is same prefix for the all the input excel files. Remaining filename can be different.
Suppose if anyone of the above files are missing then i need to find out that particular filename.
For e.g. 1. if XYZ_ABCD1_filename.xls is missing out of 5 excel files then out put should be XYZ_ABCD1_filename.xls .
input :
XYZ_ABCD2_filename.xls
XYZ_ABCD3_filename.xls
XYZ_ABCD4_filename.xls
XYZ_ABCD5_filename.xls
output:
XYZ_ABCD1_filename.xls
2. input :
XYZ_ABCD1_filename.xls
XYZ_ABCD4_filename.xls
XYZ_ABCD5_filename.xls
output:
XYZ_ABCD2_filename.xls
XYZ_ABCD3_filename.xls
Hey @Mohd-Siddiqui1,
If you have a list of expected files you can use a join tool to indentify which are missing:
The right output of the join will contain the list of missing files. You can add the file names to your data here:
Any questions or issues please ask :)
HTH!
Ira
Hi @IraWatt
Thank you for your quick response.
XYZ_ABCD1_filename(containing timestamp).xls So timestamp is also present in the filename. The only thing in the filename which is always expected and is consistent is the prefix part i.e. XYZ_ABCD1_, XYZ_ABCD2_, XYZ_ABCD3_, XYZ_ABCD4_, XYZ_ABCD5_
Can we use fuzzy logic tool for this? But i don't have knowledge on that tool.
Hey @Mohd-Siddiqui1,
You could use Fuzzy match but if your sure the first bit is consistent Regex is a better solution:
The Regex will parse the important bit we want to check then we can join that on our expected files list like before.