def chuli(tup):

    if not tup:
        return
    baseid = tup[0]
    basename = tup[1]
    #未清洗之前的企业名称
    basename_copy = tup[1]
    if "（" in basename:
        basename = basename.replace('（','(')
    if "）" in basename:
        basename = basename.replace('）',')')

    if "(" in basename:
        s_index = basename.index("(")
        e_index = basename.index(")")
        rm_str = basename[s_index:e_index+1]
        basename = basename.replace(rm_str,"")


    basename = re.sub("[A-Za-z0-9\!\%\[\]\,\，\.\。\n\、\\\\；]", "", basename)

try:
    cursor.execute(sql)
    row = cursor.fetchone()
    print(row)
    chuli(row)
    print("__________________________")
    while row:
        select_num += 1
        row = cursor.fetchone()
        print(row)
        chuli(row)
except Exception as e:
    print(e)