On Aug 14, 11:15 am, Dennis Lee Bieber <wlfr...@ix.netcom.com> wrote: > On Fri, 13 Aug 2010 09:46:34 -0700 (PDT), Praveen > <praveen.python.pl...@gmail.com> declaimed the following in > gmane.comp.python.general: > > > I have a text file in this format > > PRA 1:13 2:20 3:5 > > SRA 1:45 2:75 3:9 > > TRA 1:2 2:65 3:45 > > > pattern is- Book Chapter:Verses > > > now i have my DB schema like this > > book_id chapter_id versed_id > > Off hand, I'd say that's an incomplete schema since there is not > enough information available to reconstruct the input data... > > I'd say there should be a second relation containing > > book_id book_name > > > > > could any one give me suggestion > > Is there a possibility that a given book "name" can appear multiple > times? > > -- > Wulfraed Dennis Lee Bieber AF6VN > wlfr...@ix.netcom.com HTTP://wlfraed.home.netcom.com/
f = open("/Users/Trellisys/Desktop//BibleDB/Booktable.txt","r") bk=[] cv = [] j=1 d={} for line in f: for l in line.split(): if l.isalnum(): bk.append(j) j = j+1 else: cv.append(l.split(":")) '''for i in l.split(":"): if i.isalpha(): #print i,j j = j+1 else: #print i''' print bk print cv output [1,2,3] but i am not getting how to map chapterId and versesId with bookId Regards, Praveen -- http://mail.python.org/mailman/listinfo/python-list