How to store "3D" data? (data structure question)

Hello,

I have to parse a text file (was excel, but I translated to CSV) like
the one below, and I am not sure how to store it (to manipulate it
later).

Here is an extract of the data:

Name,Allele,RHA280,RHA801,RHA373,RHA377,HA383
TDF1,181,,,,,
,188,,,,,
,190,,,,,
,193,*,*,,,
,None,,,*,*,*
,,,,,,
TDF2,1200,*,*,,,*
,None,,,*,*,
,,,,,,
TDF3,236,,,,,
,240,,,,,
,244,*,,*,,*
,252,*,*,,,
,None,,,,*,
,,,,,,

Should I use lists? Dictionary? Or a combination?
The final goal is to "count" how many stars (*) has any "LINE" (a line
is RHA280 for instance).
RHA280 has 1 star in TDF1 and 1 star in TDF2 and 2 stars in TDF3.

I am lost because I do analize the data "line by line" (for Line in
FILE) so it is hard to count by column.



--
<a href="http://www.spreadfirefox.com/?q=affiliates&id=24672&t=1";>La
web sin popups ni spyware: Usa Firefox en lugar de Internet
Explorer</a>
.

Relevant Pages

  • Re: Fastest way to read data to populate combo controls?
    ... dumping the whole thing into a CSV and parse it using VB. ... When you talk about using a CSV, Ralph, I have no clue how VB would ... The Excel macro creates a Word document with six tables: ... If bPath Then ...
    (microsoft.public.vb.general.discussion)
  • Re: Fastest way to read data to populate combo controls?
    ... dumping the whole thing into a CSV and parse it using VB. ... When you talk about using a CSV, Ralph, I have no clue how VB would ... The Excel macro creates a Word document with six tables: ... "How To Use ADO with Excel Data from Visual Basic or VBA"http://support.microsoft.com/kb/257819 ...
    (microsoft.public.vb.general.discussion)
  • Re: Fastest way to read data to populate combo controls?
    ... dumping the whole thing into a CSV and parse it using VB. ... When you talk about using a CSV, Ralph, I have no clue how VB would ... The Excel macro creates a Word document with six tables: ... arrays, then writes these arrays into combos. ...
    (microsoft.public.vb.general.discussion)
  • Re: Best way to delimit text file
    ... even give you a chance to parse the data. ... CSV (alternatively rename the csv.csv ... Open each with Excel. ... The .csv tells Excel what to use as a delimiter and ...
    (microsoft.public.excel.programming)
  • Two sheets into one remapped? How to do it.
    ... I am opening an on line shop and download a .csv from my supplier. ... upload a .csv to my store. ... Problem is the column headers are not the same. ... that great with excel but have had some general experience with it. ...
    (microsoft.public.excel.misc)