Remove \n, " " from tuple.

2013-09-18 Thread Venkat Addala
kjafhkfhlad\fdfdsdf ghtscetylsse \ncontends the sctivity of dsfdk srylsmine N-scetyltrsnsfersse thst scts ss s cstslyst inbiotrsnsformstion fghjfg for srylsmine snd bvhghbh smine csrcinogens. Bgskjdg in ssDsC dfkdkdf in bresst snd prostrste csncer.', '', 'Msdhurs \nsgdfgs

Re: MySQLdb Help

2013-09-17 Thread Venkat Addala
s_new.group(1), row[0])) #cursor.execute(""" #update gene set descrip = %s where descrip = %s""", (rows_new.group(1), row[0])) conn.close() -- Regards Boffin On Tue, Sep 17, 2013 at 1:05 PM, Ben Finney wrote: > Venkat Addala writes: > > > I&#

MySQLdb Help

2013-09-17 Thread Venkat Addala
Hi all, I'm new to python, i am connecting mysql database with python. now i want to do sanitation on the database, like to remove "\n", extra spaces blah blah.. and update it back to mysql database. i was trying somthing, here is my code, can you please provide me solution for this.. #!/usr/b