VB6: Sum elements of tab delimited text file
Posted on 2006-10-19
I have a tab-delimited text file that looks like this:
I would like to somehow produce the sums of the counts for each species, such that my output text file would look something like:
The length of the file will vary as will the number of "Species".
I presume I would read the text file into an array, use the split function, and then loop through to sum the counts of each species element...but I can't seem to wrap my head around it.
Has anyone done this before and can provide some VB6 code?