searching a text file for repeated numbers

Un33k · October 29th, 2007, 08:17 AM

hi im looking for a way to search a text file and pick up numbers from most repeated to least repeated my text file looks like this

1,3,5,2
7,1,9,0
8,3,12,1
1,13,19,3

here "1" is repeated in every line and is the most repetitive number followed by "3" which are at indexes (0,1),(2,1) and (3,3)
i just want a method to search this text file and store these repetitive values into a variable.
i also need to know what is the typing of searching that is required here so i can study it.
any suggestions i will be thankful for.
thx

hey there

BrianWren · October 30th, 2007, 01:50 PM

I would create a collection, using the value from the file as the key, incrementing the value of that particular item every time another entry of that value was encountered. For your sample, I would end up with

Code:

 Key   Value
  1       4
  2       1
  3       3
  5       1
  7       1
  8       1
  9       1
 12       1
 13       1
 19       1

You could use an array, and redim it each time you encounter a number larger than the largest index, but if you had large numbers in your file the array would be a larger memory footprint than necessary.

I would read a line at a time, and use Split( <TheStringYoueReadIn>, ",") on the result. Then I would process the resultant array, then read another line.