Min.Sec.Milli (String) to Sec.Milli numeric field

Ive got a v string field which has the format

1.33.69

which is 1 min 33 sec 69 Milliseconds , Im just wondering what you would recommend as the best approach to get this to a numeric field which would be Mins.Mill

so in that example, the output would be 93.69

Im keen to do all the steps myself as still learning but just wondering what the best tool / approach using Alteryx would be.

Cheers

Tips and Tricks

Custom Tools

Accepted answers

atcodedog05

Hi @robertporternz

Here is my take on it. Note that all values should have mins.sec.milli secs or the formula will break since it wont be able to identify is mins.secs or secs.mill secs

Hope this helps : )

sec calculate.yxmd

All comments

Here is my take on it. Note that all values should have mins.sec.milli secs or the formula will break since it wont be able to identify is mins.secs or secs.mill secs

Hope this helps : )

sec calculate.yxmd

robertporternz

Awesome, thanks both, it really looks like using the formula tool and regex to find and replace is used a lot so ill start getting to practice that a bit more,

Really appreciate it

atcodedog05

Happy to help : ) @robertporternz

Cheers and have a nice day!

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335