Extact text from multiple Delimiters

v_mark 

Please check this post and solution https://community.powerbi.com/t5/Desktop/Splitting-Text-on-multiple-delimiters-with-DAX/m-p/2480035

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

Hi,

Try this calculated column formula

Column = mid(Data[Code],SEARCH(" - ",Data[Code],,0)+3,50)

It does not work for the third one, because that symbol is not a -.

try to write like this

Text.Trim(Text.Range(
  [Code], 
  Text.PositionOfAny(
    [Code], 
    {Character.FromNumber(8211), Character.FromNumber(45)}, 
    RelativePosition.FromEnd
  )
    + 1
))

Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhkhamWLt92LapWi6?e=vnoowN