Question

Hi All,

I am trying to create a simpel table to handle geneId and productId but the data file which i want to read in has for some genes more than one productId ex:
GeneId | ProID1 /// ProID2 /// ProID3

Now how does one input the same information without having GeneId listed in the table more than once if possible?!!!
If i read-in the info. just as it appears in the file then will the querying be a big problem since there is more than one ProID/ per gene and not to mention '///' characters!

Thanks in advance.

Hrishi

AFFX-HSAC07/X00351_3_st

AFFX-HSAC07/X00351_3_st	---	ENSG00000178309 /// ENSG00000178987 /// ENSG00000075624

AFFX-HSAC07/X00351_3_st	---	ENSG00000178309 /// ENSG00000178987 /// ENSG00000075624

AFFX-HSAC07/X00351_3_st	---	ENSG00000178309 /// ENSG00000178987 /// ENSG00000075624