kokoman789
New Member
- Joined
- Nov 7, 2013
- Messages
- 4
I have a text file with MCQ's. after importing it every line got a separate cell
The questions are not numbered and do not have any spaces between them.
Some have ABCD. some have ABCD E as answers. As you see some questions have multiple lines (sometimes even 4 lines).. same holds for answers. The only thing that I can think of is that the first Letter of the question is Always capital and is never starting with the followin 3 characters "A. " or "B. " , "C. " or "E. " .. etc
This is a bout 150000 lines of data, and what I'm trying to achieve is each question in a separate cell (possibly using concatenate function and all the cells sorted alphabetically
they look in a similar format:
The questions are not numbered and do not have any spaces between them.
Some have ABCD. some have ABCD E as answers. As you see some questions have multiple lines (sometimes even 4 lines).. same holds for answers. The only thing that I can think of is that the first Letter of the question is Always capital and is never starting with the followin 3 characters "A. " or "B. " , "C. " or "E. " .. etc
This is a bout 150000 lines of data, and what I'm trying to achieve is each question in a separate cell (possibly using concatenate function and all the cells sorted alphabetically
they look in a similar format:
so that they would look like "A patient has a history of shortness of breath and ankle edema. You would suspect A. asthma. B. emphysema. C. rhinophyma. D. cardiac insufficiency." all in one cell[TABLE="width: 361"]
<tbody>[TR]
[TD]A possible consequence for patients taking[/TD]
[/TR]
[TR]
[TD]cyclosporine is[/TD]
[/TR]
[TR]
[TD]A. erythematous gingivae
and blue mucosa[/TD]
[/TR]
[TR]
[TD]B. fibrous gingival hyperplasia.[/TD]
[/TR]
[TR]
[TD]C. loss of soft tissue attachment.[/TD]
[/TR]
[TR]
[TD]D. epithelial sloughing. .[/TD]
[/TR]
[TR]
[TD]Which of the following should NOT be[/TD]
[/TR]
[TR]
[TD]administered to a patient with chest pain[/TD]
[/TR]
[TR]
[TD]consistent with a myocardial infarction?[/TD]
[/TR]
[TR]
[TD]A. Epinephrine.[/TD]
[/TR]
[TR]
[TD]B. Nitroglycerin.[/TD]
[/TR]
[TR]
[TD]C. Oxygen.[/TD]
[/TR]
[TR]
[TD]D. Morphine.[/TD]
[/TR]
[TR]
[TD]E. Acetylsalicylic acid. .
[TABLE="width: 361"]
<tbody>[TR]
[TD]A patient has a history of shortness of[/TD]
[/TR]
[TR]
[TD]breath and ankle edema. You would[/TD]
[/TR]
[TR]
[TD]suspect[/TD]
[/TR]
[TR]
[TD]A. asthma.[/TD]
[/TR]
[TR]
[TD]B. emphysema.[/TD]
[/TR]
[TR]
[TD]C. rhinophyma.[/TD]
[/TR]
[TR]
[TD]D. cardiac insufficiency.[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: