How to get the text between delimiters of a long text using dax?

[Sar_Aan]

I have a text like this /sfdfsfdf/dsadsaa3-4rwer-34rwerfw-234-3423-efwfdsdf/rweerfdfsd/sdfsd-fsdfsdf-fsds-dfsdv-fsvsfvsvs-svfsvsv-1/sdvsvds/microsoft.compute/virtualmachines/fdadfadf434 where I have to extract only "virtual machines" using dax (not m code). How can I do that?

[Ahmedx · Accepted solution]

pls try this

Column = 

VAR _Patch = SUBSTITUTE([Data],"/","|")
VAR _LenPatch = PATHLENGTH(_Patch)
VAR _Result = PATHITEM(_Patch,_LenPatch-1)
RETURN
_Result

[Sar_Aan]

Thank you very much. This worked

[Idrissshatila]

Hello @Sar_Aan ,

refer to the following

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-extract-text-between-delimiter/m...

https://community.fabric.microsoft.com/t5/Desktop/DAX-how-to-extract-text-after-delimiter/td-p/21556...