AnsweredAssumed Answered

Importing from Text file

Question asked by dezkev on Oct 11, 2012
Latest reply on Oct 23, 2012 by robwoof

Hi All

 

I would like to import the bible into a filemaker DB I have made. (FM 12.0 advanced on windows 7).

However i am faced with some problems and I am looking for any ideas to help me with this:

 

The Bible is in a "flat" text format. Like this...

 

"CHAPTER 1

 

Ge. 1:1

In the beginning God created the heavens and the earth.

 

Ge. 1:2

Now the earth was [Or possibly became] formless and empty,

darkness was over the surface of the deep, and the Spirit of

God was hovering over the waters. "

 

etc etc...

 

My Db is a relational Db with separate TO's for Book, Chapter & verse.

WHen I try to import I see all the text going into one field only - not suprised here as thet text file has no hierarchy (or structure) and neither is it "tab separated" or "comma separated".

 

So I thought -

a) Make a flat file DB and import the text file into one global field and then parse each part using Filemakers text functions and put them into the appropriate fields. Then from this flat file DB import into the actual relational DB - not really looking forward to this one

 

b) Some how format the text and give it some structure so that it can be immported directly into the relational DB - not sure how to do this and if at all posssible.

 

thanks in advance

Outcomes