I've successfully been able to use CSVtoList to create and return key value pairs, but I'm currently trying to create part of an app that can take a CSV file and turn in into a dictionary, where the first column of a row would be the key, and the subsequent columns would be all the associated values. When I search for that key I could return the associated values. Take the following example of a sample CSV table:
Lookup.csv (117 Bytes)
I would like to convert that into a dictionary where I could search for the UPC key and return all the values for that row (description,cost,price), or possibly any value I choose, though I know the latter would be more complicated.
I've seen a lot of posts about dictionaries but they all seem to being doing something slightly different than what I need, and I'm having a tough time figuring it out. Is there possibly a better way even? Thanks for your help in advance.