[SOLVED] Convert Time hh:mm:ss.SSS in to milliseconds

vivekn1980 · 08-09-2019, 04:38 AM

want to convert first column hh:mm:ss.SSS to milliseconds in a file.

14:00:04,909 10048 370007
14:00:05,320 10048 370007
14:00:05,462 10048 370008
14:00:05,761 10048 370008
14:00:05,809 10048 370009
14:00:05,833 10048 370009
14:00:11,320 10048 370010
14:00:11,453 10048 370010
14:00:13,097 10048 370012
14:00:13,124 10048 370012
14:00:21,102 10048 370013
14:00:21,110 10048 370013
14:00:21,371 10048 370014
14:00:21,667 10048 370014
14:00:21,711 10048 370015
14:00:21,874 10048 370015
14:00:21,920 10048 370016
14:00:21,944 10048 370016

syg00 · 08-09-2019, 04:54 AM

As has been pointed out in the past, wanting is one thing - what have you attempted to solve this ?.

teckk · 08-09-2019, 07:51 AM

Some basic bash for you. You'll need to build what you want your script to do.

Code:

times="
14:00:04,909 10048 370007
14:00:05,320 10048 370007
14:00:05,462 10048 370008
14:00:05,761 10048 370008
14:00:05,809 10048 370009
14:00:05,833 10048 370009
14:00:11,320 10048 370010
14:00:11,453 10048 370010
14:00:13,097 10048 370012
14:00:13,124 10048 370012
14:00:21,102 10048 370013
14:00:21,110 10048 370013
14:00:21,371 10048 370014
14:00:21,667 10048 370014
14:00:21,711 10048 370015
14:00:21,874 10048 370015
14:00:21,920 10048 370016
14:00:21,944 10048 370016
"

a=$(echo "$times" | cut -d " " -f1)
echo "$a"

b=($(echo ${a//,/.}))
echo "$b"

for i in "${b[@]}"; do
    echo "$i"
    sleep 1
done

Code:

clock_times=(
14:00:21
14:00:27
14:00:35
14:00:44
)

for i in ${clock_times[@]}; do
    Time=$(date -d "$i" +"%s")
    echo "$Time"
done

TB0ne · 08-09-2019, 08:04 AM

Quote:

Originally Posted by vivekn1980

want to convert first column hh:mm:ss.SSS to milliseconds in a file.

Code:

14:00:04,909 10048 370007
14:00:05,320 10048 370007
14:00:05,462 10048 370008
14:00:05,761 10048 370008
14:00:05,809 10048 370009
14:00:05,833 10048 370009
14:00:11,320 10048 370010
14:00:11,453 10048 370010
14:00:13,097 10048 370012
14:00:13,124 10048 370012
14:00:21,102 10048 370013
14:00:21,110 10048 370013
14:00:21,371 10048 370014
14:00:21,667 10048 370014
14:00:21,711 10048 370015
14:00:21,874 10048 370015
14:00:21,920 10048 370016
14:00:21,944 10048 370016

Since we know what you want, how about showing us what you've actually DONE to try to accomplish what you want???

If you read the "Question Guidelines" (as you've been asked to do several times before), you'll see what WE want is for you to show effort, and not just ask for a handout. And this is nothing new for you, as you've been doing this same thing for YEARS:
https://www.linuxquestions.org/quest...ds-4175628798/
https://www.linuxquestions.org/quest...es-4175619644/
https://www.linuxquestions.org/quest...gs-4175618253/
https://www.linuxquestions.org/quest...at-4175628896/

rnturn · 08-11-2019, 10:08 PM

Quote:

Originally Posted by vivekn1980

want to convert first column hh:mm:ss.SSS to milliseconds in a file.

14:00:04,909 10048 370007

Hint: cut(1) and some fairly basic bash can easily do this. Do you understand what's happening in the following?

Code:

HR_AS_SEC=$(( $( echo "14:00:04,909 10048 370007" | cut -d: -f1 ) * 3600 ))

Q: Shouldn't this be in the "Programming" section?

TB0ne · 08-12-2019, 06:53 AM

Quote:

Originally Posted by rnturn

Hint: cut(1) and some fairly basic bash can easily do this. Do you understand what's happening in the following?

Code:

HR_AS_SEC=$(( $( echo "14:00:04,909 10048 370007" | cut -d: -f1 ) * 3600 ))

Q: Shouldn't this be in the "Programming" section?

See the OP's previous posts; the OP isn't interested in programming/working, but posts here to get a handout.