[REQUEST] For Scrappers I need your Help !

[dr_2mh]

Hello My friends,

I need to Scrape a txt file into an Excel worksheet
It has a certain pattern .......

EXAMPLE

Quote: [ Q: 1 ]
In regards to the coronary arteries, which of the following is correct?
1- The posterior interventricular artery is a branch of the circumflex artery
2- There is a lot of cross over circulation between the right and left coronary arteries
3- The circumflex artery is a branch of the right coronary artery
4- The anterior interventricular artery arises above the left posterior aortic cusp
5- The anterior interventricular artery predominantly supplies the left ventricle

Answer and Comments
Answer: 5- The anterior interventricular artery predominantly supplies the left ventricle

[ Q: 2 ]
What is the most common entrance point for contagions to cause septic cavernous sinus thrombosis?
1- Parotid region of the cheek
2- Upper lip
3- Temple
4- Gums (gum disease)
5- Ear

Answer and Comments
Answer: 2- Upper lip
The cavernous sinus lies on surrounds the body of the sphenoid bone and receives blood from the facial veins (via the superior and inferior ophthalmic veins) as well as the sphenoid and middle cerebral veins. Infections of the face including the nose, tonsils, and orbits can spread easily by this route.

I need the text between [*] to be inserted into a column, and all text after the bracket "]" and before "?" question mark into another column, and text starts with 1- into another column, ...etc

Quote:Q# Q text Ans 1 Ans 2 Ans 3 Ans 4 Correct-Answer

1

2

Anyone knows a method so I can get it done!
either using certain visual scrapper or Excel VBA Macro or any other idea ?!


Thanks!

[dr_2mh]

Bump Bump Bump