Search code examples
regexnotepad++

Regex to add leading zero in date record

Question - what is the shortest form of regex to add a leading zero into single digit in date record?

So I want to convert 8/8/2014 8:04:34 to 08/08/2014 8:04:34 - add leading zero when only one digit is presented.

The record can have two single digit entry, one single digit entry or no single digit entry. Some records can be in forms like 25/06/2014 19:50:18 or 9/06/2014 8:27:35 - in other words, some of them could be already normalized and regex needs to fix only single digit entry.

Not a regex user by any means. Your help is appreciated.

Solution

  • Use the following regex to find:

    (\d)(\d)?/(\d)(\d)?/(.*)

    Then use the following to replace:

    (?{2}\1\2:0\1)/(?{4}\3\4:0\3)/\5

    What we are using is called conditionals in terms of regex. Refer this answer for explanation.

    Make sure you have unselected the checkbox which says ". matches newline".