Convert Clock Hours to Double Digits

[Sean Perry]

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?

[guy038]

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

[Sean Perry]

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