Len dax calculated column measure to split text column

[Anonymous]

Hi Experts

I cannot use the Power Query option here as my sharepoint list url is plying up..... 

I need to split the data in image below less ["  and  "] so i just see order Picking only jus the text 

[FreemanZ · Accepted solution]

Hi @Anonymous 

You may try this with DAX, try to add a column with this:

Column = SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Example],UNICHAR(34),""), "[",""), "]", "")

I tried and it worked like this:

[Anonymous]

thank u. once again