I have a database with a memo field that has the name of a question then a {return} and then the question.
Belatedly I decided that I need this "coded" name in a separate file as well.
The name is formatted for Moodle so it looks like
::AAn nn nna:: and then a hard return.
What I want is only the information between the "::" The length of the information between these marks is not consistent, it may be shorter or longer. I plan to use and Update query but need a formula that will work for this.
Call the from field "Question" and the to field "QName"
Thanks for any help out there