Extracting string from field in lookup

[Rgk_Trail]

Hi, 

I have a  few fields in lookup from which I am trying to extract strings. I read that rex is what I should be using. 

Can anyone recommend how should I go about this ? 

I have attached lookup field and result of rex command that I want. 

- Thanks 

Rohan K.

[Rgk_Trail]

Worked like a charm ! 

Thanks a lot. 

[diogofgm]

Hi Rohan,

You can try this:
... your search | rex field="Title" "\:\s+(?<Name>[^\d]+)"

Assumptions:

- Names will always come between : and a digit.