How to extract text containing line breaks from sqlite database?

Question

Python

cur.execute("SELECT spamsg FROM addons")
                    spmmsg=cur.fetchall()
                    spmmsg1=str(spmmsg)

I have text:
Text1
Text2
Text3
When I print the value of spmmsg1 I get:
('Text1\n Text2\n Text3',)

Answer 1

\n in python is a newline character, so when you output to the console, you will be fine. Try print(spmmsg[0])

Answer 2

Replace '\\n'with '\n'in the string.