if file is empty , I need to lookup filename in datatable and extract account no mapped to filename in DT. The part of filename is dynamic , for example ( 0281_Swift_678899 ) the number after swift is dynamic. How to do look up datable to search only partial filename.
The lookup datable only search if put exact value in look up value. Kindly suggest alternate solution.