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,ITAwould 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,ITAIs 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!