Convert Clock Hours to Double Digits



  • I have multiple files where the output file shows hours from 1 to 9 as single digits, and all other hours as double digits, and need to convert all clock hours to double digits, so exhibit a)

    08/08/2020,9:20,00:50,Forged In Fire 7,ITA
    08/08/2020,10:10,00:50,Forged In Fire 7,ITA

    would become exhibit b):

    08/08/2020,09:20,00:50,Forged In Fire 7,ITA
    08/08/2020,10:10,00:50,Forged In Fire 7,ITA

    Is there a simple command to do this?



  • Hello @sean-perry and All,

    I suppose that this regex S/R will do the trick !

    SEARCH \b\d:\d\d,\d\d:\d\d

    REPLACE 0$0

    And, generally speaking, this other regex S/R should work :

    • With any delimiter, after the minute digits :

    • With, either, the syntaxes #:##, #:##Del## and #:##Del_1##Del_2##

    where Del, Del_1 and Del_2 represent delimiters

    SEARCH \b\d:\d\d([[:punct:]]\d\d([[:punct:]]\d\d)?)?

    REPLACE 0$0

    Best Regards

    guy038



  • @guy038 said in Convert Clock Hours to Double Digits:

    \b\d:\d\d([[:punct:]]\d\d([[:punct:]]\d\d)?)?

    You are correct, that did the trick and saved me a lot of time. Thank you!


Log in to reply