Hi
I need some help. I`m looking for a routine or code that will help me in reading a text file into a database. This is how the text file look.
Gen 1:1 IN THE beginning God (prepared, formed, fashioned, and) created the heavens and the earth.
Gen 1:2 The earth was without form and an empty waste, and darkness was upon the face of the very great deep. The Spirit of God was moving (hovering, brooding) over the face of the waters.
Gen 1:3 And God said, Let there be light; and there was light.
Gen 1:4 And God saw that the light was good (suitable, pleasant) {and} He approved it; and God separated the light from the darkness.
What needs to be done is to read in the book name the chapter the verse and the string, each into a different table from which searches can be done on the content.
Can Anyone help me with this or point me in the right direction where I can read up on this. Keep in mind that I am not a programmer, I do this for a hobby.I don`t worry about the code to read it into the database, that I can do myself as I have worked a lot with databases, but the manipulation of the string is a problem for me.
Thank you for any help you can provide to me.