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.
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