I am creating a database that compares different CSV's with the values in the database. It then updates the database depending upon the values in the CSV file.
Currently, there are 2 CSV's that we are comparing. I want to make the code more modular so that we can implement many more...
The problem is that there are multiple columns of item names that compare in the different csv's. For example, the columns are named "vendor_a_item_names" and "vendor_b_item_names". My visual basic script relates the records in the csv with the records in the "vendor_a_item_names" and "vendor_b_item_names".
I want to pass this value of header name as a variable. Like this "Current_name"... Then I can do something like FindFirst Current_Name_Value
Is there any way to do this? I can't think of a way...
Currently, there are 2 CSV's that we are comparing. I want to make the code more modular so that we can implement many more...
The problem is that there are multiple columns of item names that compare in the different csv's. For example, the columns are named "vendor_a_item_names" and "vendor_b_item_names". My visual basic script relates the records in the csv with the records in the "vendor_a_item_names" and "vendor_b_item_names".
I want to pass this value of header name as a variable. Like this "Current_name"... Then I can do something like FindFirst Current_Name_Value
Is there any way to do this? I can't think of a way...
