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\dREPLACE
0$0And, 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$0Best 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!
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login