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
On Mon, Feb 06, 2006 at 10:54:49 -0500,
Hrishikesh Deshmukh <hdeshmuk@gmail.com> wrote:
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 /// ProID3Now 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!
Write a filter which reads your file and writes something suitable for copy.
In fact if you use perl, you could have the script feed stuff to copy as
it is being read in.