regex101: Parse OFX date / date-time

^start of line

Group year(?<year>\d{4})

\d{4}a digit, repeated exactly 4 times

Non-Capturing Group(?:(?<month>\d{2})(?:(?<day>\d{2})(?:(?<hour>\d{2})(?:(?<minute>\d{2})(?:(?<second>\d{2})(?:.(?<millis>\d{3})(?:\[(?:(?<offsetSign>[+-]?)(?<offsetHour>\d{1,2}))(?:.(?<offsetMin>\d{2}))?(?::(?<tz>.*)?)?\])?)?)?)?)?)?)?

?repeats the group contents below at most once:

Group month(?<month>\d{2})

\d{2}a digit, repeated exactly 2 times

Non-Capturing Group(?:(?<day>\d{2})(?:(?<hour>\d{2})(?:(?<minute>\d{2})(?:(?<second>\d{2})(?:.(?<millis>\d{3})(?:\[(?:(?<offsetSign>[+-]?)(?<offsetHour>\d{1,2}))(?:.(?<offsetMin>\d{2}))?(?::(?<tz>.*)?)?\])?)?)?)?)?)?

?repeats the group contents below at most once:

Group day(?<day>\d{2})

\d{2}a digit, repeated exactly 2 times

Non-Capturing Group(?:(?<hour>\d{2})(?:(?<minute>\d{2})(?:(?<second>\d{2})(?:.(?<millis>\d{3})(?:\[(?:(?<offsetSign>[+-]?)(?<offsetHour>\d{1,2}))(?:.(?<offsetMin>\d{2}))?(?::(?<tz>.*)?)?\])?)?)?)?)?

?repeats the group contents below at most once:

Group hour(?<hour>\d{2})

\d{2}a digit, repeated exactly 2 times

Non-Capturing Group(?:(?<minute>\d{2})(?:(?<second>\d{2})(?:.(?<millis>\d{3})(?:\[(?:(?<offsetSign>[+-]?)(?<offsetHour>\d{1,2}))(?:.(?<offsetMin>\d{2}))?(?::(?<tz>.*)?)?\])?)?)?)?

?repeats the group contents below at most once:

Group minute(?<minute>\d{2})

\d{2}a digit, repeated exactly 2 times

Non-Capturing Group(?:(?<second>\d{2})(?:.(?<millis>\d{3})(?:\[(?:(?<offsetSign>[+-]?)(?<offsetHour>\d{1,2}))(?:.(?<offsetMin>\d{2}))?(?::(?<tz>.*)?)?\])?)?)?

?repeats the group contents below at most once:

Group second(?<second>\d{2})

\d{2}a digit, repeated exactly 2 times

Non-Capturing Group(?:.(?<millis>\d{3})(?:\[(?:(?<offsetSign>[+-]?)(?<offsetHour>\d{1,2}))(?:.(?<offsetMin>\d{2}))?(?::(?<tz>.*)?)?\])?)?

?repeats the group contents below at most once:

.any character (except for line terminators)

Group millis(?<millis>\d{3})

\d{3}a digit, repeated exactly 3 times

Non-Capturing Group(?:\[(?:(?<offsetSign>[+-]?)(?<offsetHour>\d{1,2}))(?:.(?<offsetMin>\d{2}))?(?::(?<tz>.*)?)?\])?

?repeats the group contents below at most once:

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

Non-Capturing Group(?:(?<offsetSign>[+-]?)(?<offsetHour>\d{1,2}))

Group offsetSign(?<offsetSign>[+-]?)

Character Class[+-]?

?matches at most one character from the set below:

+the literal + (43₁₀ / 53₈ / 2B₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

Group offsetHour(?<offsetHour>\d{1,2})

\d{1,2}a digit, repeated between 1 and 2 times

Non-Capturing Group(?:.(?<offsetMin>\d{2}))?

?repeats the group contents below at most once:

.any character (except for line terminators)

Group offsetMin(?<offsetMin>\d{2})

\d{2}a digit, repeated exactly 2 times

Non-Capturing Group(?::(?<tz>.*)?)?

?repeats the group contents below at most once:

:the literal : (58₁₀ / 72₈ / 3A₁₆)

Group tz(?<tz>.*)?

?repeats the group contents below at most once:

.*any character (except for line terminators), repeated any number of times

\]the literal ] (93₁₀ / 135₈ / 5D₁₆)

$end of line

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Search reference

Regular Expression

^(?<year>\d{4})(?:(?<month>\d{2})(?:(?<day>\d{2})(?:(?<hour>\d{2})(?:(?<minute>\d{2})(?:(?<second>\d{2})(?:.(?<millis>\d{3})(?:\[(?:(?<offsetSign>[+-]?)(?<offsetHour>\d{1,2}))(?:.(?<offsetMin>\d{2}))?(?::(?<tz>.*)?)?\])?)?)?)?)?)?)?$

New

1996
199610
19961005
1996100513
199610051322
19961005132200
19961005132200.124
19961005132200.124[-5]
19961005132200.124[-5:EST]
19961005132200.124[-5.30:EST]
19961005132200.124[-5.30:]
19961005132200.124[-5.30]
19961005132200.124[+5]
19961005132200.124[+5.30]
19961005132200.124[+5:EST]
19961005132200.124[+5.30:EST]
19961005132200.124[+5.30:]
19961005132200.124[5]
19961005132200.124[5.30]
19961005132200.124[5:EST]
19961005132200.124[5.30:EST]
19961005132200.124[5.30:]

Regular Expressions 101

Regular Expression

Extraction