AnsweredAssumed Answered

Importing lines of a plain text file into FileMaker fields

Question asked by Jax on Aug 29, 2016
Latest reply on Aug 30, 2016 by Jax

Hi guys,

 

I'm trying to get multiple choice quiz questions into a FileMaker database. The information is in a plain text file. Question and options are simply separated by returns:

 

Where in the cell is the genome located?
Mostly in the cytosol.
Mostly in the mitochondria.
[X] Mostly in the nucleus.
Stored in the membrane.
Stored in RNA.

 

Next question...

 

Each question has 5 options, one of which is correct [X]. There's an empty line between questions.

 

What's a good approach to get this into a FileMaker database with separate fields for the questions, the options, and the correct solution?

 

All the best

Outcomes