Thread: 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 /// 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!

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.