+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: convert text to sqlite3 (/thread-9461.html)
convert text to sqlite3 - issac_n - Apr-10-2018
I am looking for a way to read texxt file then convert into database(sqlite3).
any recommended materials?
RE: convert text to sqlite3 - buran - Apr-10-2018
csv module and sqlite3 module from standard library
of course knowledge to work with files is presumed.
RE: convert text to sqlite3 - issac_n - Apr-11-2018
(Apr-10-2018, 12:57 PM)buran Wrote: csv module and sqlite3 module from standard library
of course knowledge to work with files is presumed.
U mean txt can be process like csv?
RE: convert text to sqlite3 - Larz60+ - Apr-11-2018
Quote:U mean txt can be process like csv?cvs can be processed as text, because it is text.
Text would have to be comma delimitered in order to be processed as cvs.
RE: convert text to sqlite3 - buran - Apr-11-2018
(Apr-11-2018, 03:56 AM)Larz60+ Wrote: Text would have to be comma delimiteredHave to be delimited, you can specify the delimiter
RE: convert text to sqlite3 - Larz60+ - Apr-11-2018
Yes, of course.