In one folder(F:\Bank\Formdetails\) multiple files are there in pdf and excel format, want to zip only if same string name found in pdf and excel
1) If excel name is "Dbk_bank.xlsx" and pdf is "Investor_Dbk_bank.pdf" then it should do zip in path (F:\Bank\Formdetails\) with name Dbk.zip
2)If excel name is "Hdfc_bank.xlsx" and pdf is "Investor_hdfc_bank.pdf" then it should do zip with name Hdfc.zip in same folder
1) If excel name is "Dbk_bank.xlsx" and pdf is "Investor_Dbk_bank.pdf" then it should do zip in path (F:\Bank\Formdetails\) with name Dbk.zip
2)If excel name is "Hdfc_bank.xlsx" and pdf is "Investor_hdfc_bank.pdf" then it should do zip with name Hdfc.zip in same folder