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 |
| <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!!!!
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])
3 Replies
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 ":"?
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])