I'm struggling with regular expressions at present, and I have a specific problem I need to solve.
Where a named value after Chief Investigator exists (Here Mr A Smith), I want to extract Mr A Smith only. I know that in all cases, 'Mr A Smith' will be preceeded and followed by two astericks.
"**Chief Investigator:**Mr A Smith
**Sponsor**: xxxxxxxxxxx
**Study Team Contact**: xxxxxxxxx
**Grant deadline**:
**Date EC meeting completed**: xxxxxxxxxx
**Upload Method**: xxxx
Any ideas gratefully recieved!