Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
convert text to sqlite3
#1
I am looking for a way to read texxt file then convert into database(sqlite3).
any recommended materials?
Reply
#2
csv module and sqlite3 module from standard library

of course knowledge to work with files is presumed.
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply
#3
(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?
Reply
#4
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.
Reply
#5
(Apr-11-2018, 03:56 AM)Larz60+ Wrote: Text would have to be comma delimitered
Have to be delimited, you can specify the delimiter
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply
#6
Yes, of course.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Separate text files and convert into csv marfer 6 2,859 Dec-10-2021, 12:09 PM
Last Post: marfer
  How to convert binary data into text? ZYSIA 3 2,622 Jul-16-2021, 04:18 PM
Last Post: deanhystad
  how to create a tool with tkinter to convert img to text rachidel07 3 2,571 Feb-05-2021, 12:21 PM
Last Post: deanhystad
  [split] How to convert the CSV text file into a txt file Pinto94 5 3,315 Dec-23-2020, 08:04 AM
Last Post: ndc85430
  Convert Excel file to Text file marvel_plato 6 19,645 Jul-17-2020, 01:45 PM
Last Post: marvel_plato
  Convert text file date into specific format jacklee26 11 9,800 May-15-2018, 07:36 AM
Last Post: buran
  unable to convert text file in dictionary purnima1 6 4,290 Apr-02-2018, 07:44 AM
Last Post: purnima1
  convert text file data to HTML table in python Tirumal 5 12,491 Dec-29-2017, 04:44 PM
Last Post: buran
  Convert grib files to text files tuxman 6 9,291 Sep-15-2017, 03:26 PM
Last Post: nilamo
  How to convert Text file contents into a dictionary. tannishpage 12 51,341 May-11-2017, 03:49 PM
Last Post: nilamo

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020