Unwrap text for Import and reformat as table (1 Viewer)

[vbaInet]

If you want it to go beyond d, it's very simple. Just change these two lines:

    Const RESP_1            As String = "[a-[COLOR="blue"]zA-Z[/COLOR]][.)]"
    Const RESP_2            As String = "[*][a-[COLOR="Blue"]zA-Z[/COLOR]][.)]"

... now it will properly do lower and upper case from a to z.

As for the last variation, give that some thought or get in touch with whoever is doing that and get them to standardise.

I know that you say that you can't enforce standardisation at the moment, but you can try and reach out to those involved, especially those with not so ideal formatting. At least some of them will listen.

 

[sxschech]

Thank you vbaInet. Changing RESP_1 and RESP_2 worked. I'll see if I can have a conversation about it, but I imagine since the incidence of odd formatted questions is low, probably won't make a difference. I think that it is more a layout issue in the online exam system as to how the question could be displayed without making it a part of the response.

 

[vbaInet]

Good!

Anyway, I would advise that you go through the code and digest it and if you have any specific questions just ask. Any future developments/enhancements is now in your hands.