Extract Text

[Anonymous]

Hi folks,

I need some help.

Need to extract a string from another string. 

<SOME TEXT HERE> : It can be a great text or a simple text.

It can be in DAX or in Function M

TEXT	Result
<SOME TEXT HERE> Accepted by: Williams Portela <SOME TEXT HERE>	Williams Portela
<SOME TEXT HERE> Accepted by: Rose Davis Harris <SOME TEXT HERE>	Rose Davis
<SOME TEXT HERE> Accepted by: James Anderson Taylor <SOME TEXT HERE>	James Anderson

Can anyone help me?

TKssss!!!!

[fhill]

TEXT	Result
<SOME TEXT HERE> Accepted by: Williams Portela <SOME TEXT HERE>	Williams Portela
<SOME TEXT HERE> Accepted by: Rose Davis Harris <SOME TEXT HERE>	Rose Davis
<SOME TEXT HERE> Accepted by: James Anderson Taylor <SOME TEXT HERE>	James Anderson

Are you OK with logic that says 'the next two words after a ":"?

[Anonymous]

exacly

[fhill · Accepted solution]

You can Merge these all together with VAR or nested logic, but I've broken them out to show the thought process flow...

Colon Search = FIND(":", Table1[TEXT],,1)

1st Space after Colon = FIND(" ", Table1[TEXT], (Table1[Colon Search]+2) ,1)

2nd Space after Colon = FIND(" ", Table1[TEXT], (Table1[1st Space after Colon]+1) ,1)

Name = MID(Table1[TEXT],Table1[Colon Search]+1,[2nd Space after Colon]-Table1[Colon Search])