I am doing a Reconciliation through CSV Excel.
I have to compare the files through the column “Account”
The rows of the first file has to run through the second and third files to find matching or unmatched record.
My issue is that my first file “csv1” the column account has 2 number while the other files the column account has 3 numbers
For instance: columns; Name Age Account
File 1 has the record: Dany 30 23
File 2 has: Dany 30 123
To compare, I should be able to ignore the first number in file1 for column account.
My code is attached. Can anyone please help?
ReadingExcel copy 2.zip (19.8 KB)