I have an input.txt with two columns and the following sample data. the empty strings between two columns are unknown.
Also I have TBL.txt with the following data
How to create a vbscript which will write to update.sql with the following output?
Update TBL1 set name='JOHN' where name='TOM';
Update TBL2 set name='JOHN' where name='TOM';
Update TBL1 set name='DAVE' where name='JOHN';
Update TBL2 set name='DAVE' where name='JOHN';
Please provide sample.