python save data on csv file and replace new lines

Question

I want to extract data from mysql db and save it on csv file, problem is in my db is present values with \n (new lines). i want to replace this new lines with " " or \n, my curent code is :

def cauta_db(domain_ip, db_username, db_password):
        db = MySQLdb.connect(host=domain_ip, user=db_username, passwd=db_password)
        cur = db.cursor()
        cur.execute(sql_cmd_select_db)
        for database in cur.fetchall() :
            cur.execute("USE {};".format( database[0]) )
            cur.execute("SELECT * FROM {};".format(database[1]))
            file_to_save = creaza_dir(domain_ip, database[0], database[1])

            with open(file_to_save,'wb') as out:
                csv_out = csv.writer(out, delimiter =';', lineterminator='\n')
                for row in cur.fetchall():
                    csv_out.writerow(row)

how i can replace new lines present in database and replace with \\n or space ?

score 2 · Accepted Answer · 2018-08-22 11:15:24Z

2

You may want to check out method rstrip

The method rstrip() returns a copy of the string in which all chars have been stripped from the end of the string (default whitespace characters).

Since tuples are immutable create a list with rstrip()'ed tuple elements and then cast that list as a tuple and write it to file:

    for row in cur.fetchall():
      r = []
      for v in row:
        r.append(v.rstrip())
      row = tuple(r)
      csv_out.writerow(row)

edited Aug 22, 2018 at 11:15

answered Aug 22, 2018 at 10:42

user10259046

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

2 Comments

user10259046 Over a year ago

Could You please clarify where are the new line characters, then? At the end of each element in the tuple?

Bello Daniel Over a year ago

i want to replace new line from each element in the tuple.

Collectives™ on Stack Overflow

python save data on csv file and replace new lines

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related