How can I derive a name in the middle of text?

 Building on Matt's approach, you can use the new line character which is \n as a delimiter.

//Get all the text parts between colons(:)
var text texta = Trim(Part([Descsription],1,"\n"));
var text textb = Trim(Part([Descsription],2,"\n"));
var text textc = Trim(Part([Descsription],3,"\n"));
var text textd = Trim(Part([Descsription],3,"n"));


var text ConsultantLine = 
IF(
Begins($texta, "Consultant"), $texta,
Begins($textb, "Consultant"), $textb,
Begins($textc, "Consultant"), $textc,
Begins($textd, "Consultant"), $texta)

Trim(Right($ConsultantLine,":"))