I would do this in a script component by using the .NET parse method.
Doing this in a derived column would be too complicated.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP