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 |
