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

[robertporternz]

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

[binuacs]

@robertporternz 

[atcodedog05 · Accepted solution]

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 : )

[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!