<div dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif;color:rgb(11,83,148)"><div class="gmail_default">hey Ben, </div><div class="gmail_default"><br></div><div class="gmail_default">Thanks for your solution, i am done with this before, now i'm having problem after deleting \n and extra spaces, i want to update it back it again to mysql db. </div>
<div class="gmail_default"><br></div><div class="gmail_default">For this i tried using regular expression check this code;</div><div class="gmail_default"><br></div><div class="gmail_default"><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<font color="#0b5394" face="tahoma, sans-serif"># -*- coding: utf-8 -*-</font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif">import re</font></div>
<div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif">import MySQLdb</font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<font color="#0b5394" face="tahoma, sans-serif"><br></font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif">pattern = re.compile('@(.*)@.*$')</font></div>
<div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif"><br></font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<font color="#0b5394" face="tahoma, sans-serif">conn = MySQLdb.connect(</font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif"> host='localhost', user='root',</font></div>
<div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif"> passwd='pass123', db='workbench', charset='utf8')</font></div>
<div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif"><br></font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<font color="#0b5394" face="tahoma, sans-serif">cursor = conn.cursor()</font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif"><br>
</font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif">cursor.execute("""</font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<font color="#0b5394" face="tahoma, sans-serif"> SELECT * FROM gene where gene_id=13 AND `descrip` regexp "^@.*@.*$" LIMIT 1""")</font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<font color="#0b5394" face="tahoma, sans-serif">rows = cursor.fetchall()</font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif">for row in rows:</font></div>
<div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif"> rows_new = pattern.match(row[1])</font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<font color="#0b5394" face="tahoma, sans-serif">if rows_new.group(1) is not None:</font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif"> cursor.execute("""</font></div>
<div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif"> update gene set descrip = %s where descrip = %s""", (rows_new.group(1), row[0]))</font></div>
<div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif"> #cursor.execute("""</font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<font color="#0b5394" face="tahoma, sans-serif"> #update gene set descrip = %s where descrip = %s""", (rows_new.group(1), row[0]))</font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<font color="#0b5394" face="tahoma, sans-serif"> </font></div><div class="gmail_default" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><font color="#0b5394" face="tahoma, sans-serif"> conn.close()</font></div>
<div><font color="#0b5394" face="tahoma, sans-serif"><br></font></div></div></div><div class="gmail_extra"><br clear="all"><div><div dir="ltr"><span style="font-family:trebuchet ms,sans-serif"><font style="color:rgb(136,136,136);font-size:13px;background-color:rgb(255,255,255)"><span style="color:rgb(11,83,148)"><span style="color:rgb(0,0,0)">--</span><br>
Regards </span><br></font></span><div><span style="font-family:trebuchet ms,sans-serif"></span><div class="gmail_default" style="font-family:tahoma,sans-serif;color:rgb(11,83,148);display:inline">Boffin</div><br></div><div>
<br></div><div><div style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><br></div></div></div></div>
<br><br><div class="gmail_quote">On Tue, Sep 17, 2013 at 1:05 PM, Ben Finney <span dir="ltr"><<a href="mailto:ben+python@benfinney.id.au" target="_blank">ben+python@benfinney.id.au</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Venkat Addala <<a href="mailto:venkat.boffin@gmail.com">venkat.boffin@gmail.com</a>> writes:<br>
<br>
> I'm new to python<br>
<br>
Welcome! Congratulations on choosing Python for programming.<br>
<div class="im"><br>
> i am connecting mysql database with python. now i want to do<br>
> sanitation on the database, like to remove "\n", extra spaces blah<br>
> blah.. and update it back to mysql database.<br>
<br>
<br>
> i was trying somthing, here is my code, can you please provide me<br>
> solution for this..<br>
<br>
</div>Thank you for providing a small, complete example.<br>
<br>
You should also describe what behaviour you expect, and what behaviour<br>
you're getting instead. What happens, and how are you expecting it to be<br>
different?<br>
<div class="im"><br>
> #!/usr/bin/python<br>
> import MySQLdb as mdb<br>
><br>
> con = mdb.connect('localhost', 'root', 'pass@123', 'workbench');<br>
<br>
</div>There's no need to end Python statements with a semicolon; it's only<br>
confusing to do it.<br>
<div class="im"><br>
> rows = cur.fetchall()<br>
> for row in rows:<br>
<br>
</div>You never use ‘rows’ for anything else, so you may as well forget it and<br>
just iterate directly over the return value::<br>
<br>
for row in cur.fetchall():<br>
<div class="im"><br>
> row_new = row[0].split("\n", " ")<br>
<br>
</div>Read the documentation for ‘str.split’ to see what is wrong with the<br>
above call.<br>
<br>
<br>
You might also be interested in the ‘python-tutor’ forum, specially<br>
designed for beginners with basic questions about Python<br>
<URL:<a href="http://mail.python.org/mailman/listinfo/tutor" target="_blank">http://mail.python.org/mailman/listinfo/tutor</a>><br>
<URL:<a href="http://dir.gmane.org/gmane.comp.python.tutor" target="_blank">http://dir.gmane.org/gmane.comp.python.tutor</a>>.<br>
<br>
Good hunting to you!<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
\ “Sunday: A day given over by Americans to wishing that they |<br>
`\ themselves were dead and in Heaven, and that their neighbors |<br>
_o__) were dead and in Hell.” —Henry L. Mencken |<br>
Ben Finney<br>
<br>
--<br>
<a href="https://mail.python.org/mailman/listinfo/python-list" target="_blank">https://mail.python.org/mailman/listinfo/python-list</a><br>
</font></span></blockquote></div><br></div></div>