Try with Regex expression
Use Assign activity
StrInput = System.Text.RegularExpressions.Regex.Replace(YourString.Trim,"\|","").Tostring.Trim
Use Generate Data table activity
Input => StrInput
Output → Create a new variable in the Output (DtOutput)
Regards
Gokul