How to delete some characters from multiple strings?

Question

I am trying to get country names from database and paste them to QComboBox. Everything working fine except that tuples coming out of db table like ('Afghanistan',) , ('Angola',) ... The question is how to delete that unuseful characters from tuples. The code is:

countries = []
try:
    conn = MySQLdb.connect(host='localhost', user='root', passwd='*****', db='world')
    cursor = conn.cursor()
    try:
        cursor.execute("SELECT Name from country")
        while True:
            rows = cursor.fetchone()
            if rows == None:
                break
            else:
                countries.append(rows)
    except:
        print('Error CURSOR')
    cursor.close()
    conn.close()
except:
    pass
for i in countries:
    self.country_cbox.addItem(str(i)) # Converting to string
print(countries)
self.add_worker.show()
self.add_worker.exec_()

Try countries.append(rows.Name) or rows[0]

metmirr
– metmirr

2017-02-28 17:06:02 +00:00
Commented Feb 28, 2017 at 17:06 — metmirr
– metmirr, Commented Feb 28, 2017 at 17:06
Thanks man. My brain is tired i must take some coffee :)

Suhrob Kamolov
– Suhrob Kamolov

2017-02-28 17:11:42 +00:00
Commented Feb 28, 2017 at 17:11 — Suhrob Kamolov
– Suhrob Kamolov, Commented Feb 28, 2017 at 17:11
Good idea Enjoy it ;)

metmirr
– metmirr

2017-02-28 17:12:48 +00:00
Commented Feb 28, 2017 at 17:12 — metmirr
– metmirr, Commented Feb 28, 2017 at 17:12
@metmirr Can you post your comment as an answer? Thanks!

alex
– alex

2018-10-29 17:51:36 +00:00
Commented Oct 29, 2018 at 17:51 — alex
– alex, Commented Oct 29, 2018 at 17:51
@alex Posted it.

metmirr
– metmirr

2018-10-29 18:03:06 +00:00
Commented Oct 29, 2018 at 18:03 — metmirr
– metmirr, Commented Oct 29, 2018 at 18:03

metmirr · Accepted Answer · 2018-10-29 18:02:15Z

1

You can use column name or tuple index to delete value:

countries.append(rows.Name)  # column name
# or use 
rows[0]  # column index

answered Oct 29, 2018 at 18:02

metmirr

4,3222 gold badges23 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to delete some characters from multiple strings?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related