Recommend debugger...

2006-01-19 Thread SG Edwards
Dear all, I have started using the perl -d dubugger option to step through my programs but it seems pretty crude and not too user friendly. Can anyone reccommend a good freeware graphical debugger? I am writing fairly simple text manipulation scripts. Thanks, Stephen Edwards -- To unsubsc

Count number of times matched

2005-12-01 Thread SG Edwards
Hi folks, If I want to count the number of times that a match occurs in a line is there a way of doing this, if there is I have not found it! e.g. $line="This is a sentence about matching sentences.\n"; $line=~/sentence/ig; So I will have matched "sentence" twice and I want to record this.

Simple HASH query

2005-03-16 Thread SG Edwards
Hi, I am using bioperl to get the primary id of a protein out of a flat file as follows: while ($seq_obj = $seqio_obj->next_seq){ my $primary_id = $seq_obj->primary_id; print $primary_id; } exit; However, this returns: Bio::Seq::RichSeq=HASH(0xa1a1b7c) How do I get the actual value I want ou

Re: Compare 2 database queries?!

2005-03-15 Thread SG Edwards
olumn "p09466" does not exist at extract_ann_uni.pl line 41, line 155." I know the SQL command is correct because I checked it manually but I don't know why it says the column doesn't exist?! Please help!! Quoting Chris Devers <[EMAIL PROTECTED]>: > On Mon, 14

Compare 2 database queries?!

2005-03-14 Thread SG Edwards
Hi, I have a perl script that queries a protein database (uniprot) and puts protein data from the query into a PostgreSQL table. However, what I would like it to do is check if the protein is in my database already!! In my database I have a table with a column containing all the protein_ids so I

writing to CSV file

2005-03-11 Thread SG Edwards
Hi, I have a program that extracts variables from a list of flatfiles and I want to insert these variables into a PostreSQL database. I was planning on creating a CSV file with a line allocated for each file which can then be inserted into the database using the COPY command. Is the best way t

extract uniprot flatfile

2005-03-07 Thread SG Edwards
Hi, I am writing a perl program that will extract data from a UniProt (this is a protein database!) flatfile so that I can automatically put data into my PostgreSQL database. I am taking out name, protein ID number, references etc from the file. Does anyone know if there is a script available