How to browse through a csv file


#1

Hi,
I have a csv file that I want to go through using Kantu’s csvRead to save some of the values. However, all the values are arranged in a single line, and I do not know in advance the number of values (# of columns). So how can I achieve this? How to access the total number of columns for instance ?
Furthermore, I would need to construct a dictionary to store some values. If that’s possible, how can I push key-value pairs ?
Thanks for your help.


#2

For the column question: What is the max. number of columns in the file?

Within the storeEval command you have full access to Javascript. With this, and storedVars you can access values from an array.


#3

Thanks, I figured out how to do it.