Return string after occurence of specific text

[Anonymous]

Afternoon All

I wonder if any kind person could perhaps suggets the relevant DAX I would need to add a calculated column.

I would like the DAX to search a field for the occurence of the word Asset and where that word occurs I would then like the next string of text/numbers returned before the next space occurs (bearing in mind there is likely a space between the word asset and the string I would then like to return).

I hope that makes sense!

[Anonymous · Accepted solution]

CONTAINSSTRING has the same function LIKE in SQL, so you in indetify the index of the colonunm, the next steps is using the index for return string