Forum Discussion
Extract Text
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 ...
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])
| 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 ":"?
exacly
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])