remove character before "|" or ":"

[Anonymous]

hello

i need to remove character before this symbol "|" or ":" for example :

fi|TPZ - FTSA-Audio  must becomes TPZ - FTSA-Audio

Any help please?

Many thanks

[speedramps]

Please consider this solution and leave kudos

newstring =
--  *** replace VAR inputstring = "fi|TPZ - FTSA-Audio"  with VAR inputstring = yourtable[yourcolumn]

VAR inputstring = "fi|TPZ - FTSA-Audio"

VAR temptext = SUBSTITUTE(inputstring, "|", "")

RETURN

SUBSTITUTE(temptext , ":", "")

Note this is DAX solution because you posted the question in the DAX section, but you could use a M power Quesry solution.

[stevedep · Accepted solution]

Calculated Column:

NewValue = RIGHT('Table'[Column1];(LEN([Column1])-FIND("|";'Table'[Column1];1;0)))

Hope it helps, please mark as solution if so. Thumbs up for the effort are appreciated. 

Kind regards, Steve.