i have a question concerning the best functions or mix of to use from this library to get a "lookup" style script. honestly, I think that the CSV_MatchCellColumn() do the trick, but would like input of those better versed in programming than i before i move forward. here is what i am trying to accomplish:
In my job I get several files of different types employees; each employee type has a specific employee code convention, between 3 and 6 characters. Each month i get a new excel spreadsheet with all the edits from New and attrition. What i want to do type only the code into a gui I've created that returns the employee first last name into a text field on the gui.
When I converted the Excel file csv file, it left many empty fields ",,,,,,,,,,,,,,,,,,,,,,," which I'm not sure how I can get rid of them,other than to delete them manually, They are close to 1000 so that isn't an option i would like take But that aside, would the CSV_MatchCellColumn() function ONLY search in the employee code column (I believe it's the 9th column), that way the entire needn't be read? And if answer to question YES,how would i return the first and second columns?
If is the incorrect topic,feel free to move it; I only placed it here because question was so closely related the library