Forum Discussion
Data (time format) Transformation
Hello I am having problems transforming time duration. The problem is I am getting the data from XML type file. Time format in the file looks : Uptime Downtime 176d 08h 07m 06s ...
Hi,
You could try to clean the data using find an replace. E.g. find "h" and replace it with "". This way you will get data that you can transform without issues or split based on delimiter " "
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!