I have tried with no success at all to capture the Chief Investigators name. The format of the input text seems to be something like this:
**Chief Investigator:**Prof Joe Blogss Sponsor: Academic Medical Centre - University of Universities Study Team Contact: NM NM@abc.com Grant deadline: Date EC meeting completed: 31/05/2017 Upload Method: abcd
Ideally I would like to collect the name of the Chief Investigator, the name of the Sponsor, the Study Team contact, the Grant deadline, the Date EC meeting completed and the Upload method but I have no idea how to do this. Can someone help me to write a Regular Expression that I can use in data studio please?