00:00:22.17 mp3 time to millisecond

[dynamitemedia]

i can find how to do the opposite but i want to take

00:00:22.17  and put into milliseconds

which would be 22017 ?? or no

seems like it should be super simple but not finding it anywhere.

i get a bunch of audio files with that time stamp and i and i want to to convert to milliseconds

thanks!

[water]

What have you tried yourself so far?

[mikell]

This reminds me something 

Msgbox(0,"", Convert2ms("00:00:22.17") )

Func Convert2ms($sTime) ;format "HH:MM:SS.ms", no error / validity check for input!
    Return Execute("'" & StringRegExpReplace($sTime, "(\d+):(\d+):(\d+)\.(\d*)", _ 
            "' & $1*3600*1000+$2*60*1000+$3*1000+$4 & '") & "'")
EndFunc

[TheSaint]

Check out the StringSplit function as one method to get an array, which you will need to do twice.

Hours times 60 to get minutes.

Minutes times 60 to get seconds.

Seconds times 1000 to get milliseconds.

We could provide the code easy enough, but I believe in helping those who help themselves, so as water said, provide us with what you have tried so far, or with what I have now given you a clue to, if necessary.

We can help fine tune any issues you can't surmount.

[TheSaint]

@mikell - I know you are trying to be helpful, but giving a golden platter solution like that to a seeming newbie, is not really teaching them anything.

As they say, best to learn to walk before learning to ride.

[mikell]

TheSaint,

You are obviously right but I couldn't help but posting it 

BTW I would say lazy instead of newbie

[water]

It is a quite advanced solution (at least for me as I'm not good with regular expressions).

I would have - like TheSaint - suggested to start with StringSplit.

[TheSaint]

TheSaint,

You are obviously right but I couldn't help but posting it 

BTW I would say lazy instead of newbie

Nothing wrong with posting it once they had tried and succeeded with an easier method.

After all, they won't be a newbie forever and many others will see this topic perhaps, and benefit from an advanced solution.

Probably not water and I though, as we tend to avoid RegExp stuff ... so we can sleep at night.

Edited April 25, 2015 by TheSaint

[dynamitemedia]

I was not being lazy if you see all my posts here i show my solutions every time, not to mention i ask to be sent in right direction...  this topic was not covered anywhere i could find.

i got stuck for hours and wanted to see if anyone had any ideas and when i woke up could work again, no reason to start making assumptions about my laziness etc.

I didn't know where to start is why i started the thread. never said hand me over code.   thanks mikell that is what i was thinking about b4 i went to bed last night.  i wasnt sure it would be that simple i thought i would need to be doing some addition etc... 

 

[jguinch]

@Mikell : just a small remark. You can remove your concatenation and juste keep the calculation : 

Func Convert2ms($sTime)
    Return Execute(StringRegExpReplace($sTime, "(\d+):(\d+):(\d+)\.(\d*)", "($1*3600+$2*60+$3)*1000+$4") )
EndFunc

 

Edited April 25, 2015 by jguinch

[UEZ]

Non regex version:

Func Convert2ms($sTime)
    Return StringLeft($sTime, 2) * 3600000 + StringMid($sTime, 4, 2) * 60000 + StringMid($sTime, 7, 2) * 1000 + StringRight($sTime, 2)
EndFunc

 

[mikell]

jguinch,

Thanks for the tip. Less quotes, mmm... lovely  

 

UEZ,

I remember the former topic, there is one example more using StringSplit   

[UEZ]

Regex is not only for beginners not easy to understand. Further many ways lead to Rome and it is always good to see more ways.