Extract string from difference delimiter

[Anonymous]

Dear friends

how can i extract string3  from word with delimiter like this

string1 > string2 > string3 (string4)

Thanks in advance for any advice

[v-lionel-msft]

Hi @Anonymous ,

Please provide sample data and expected output.

Do you want to use DAX to extract string3 or use M to extract string3?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , First Split with (, then split the first column by > ( with space if needed), or remove space later

refer my video for option:https://www.youtube.com/watch?v=FyO9Vmhcfag

or function : https://www.youtube.com/watch?v=Fn5mNEuRNVg