assay
regex

extract-return-mode-2-capture-groups-from-first-match

Subject
REGEXEXTRACT
Category
value
Formula
=REGEXEXTRACT("2025-03-01", "(\d{4})-(\d{2})-(\d{2})", 2)
Canonical
{2025, 03, 01}

Owning divergences (1)

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets diverge #N/A
excel match {2025, 03, 01}
lattice match {2025, 03, 01}
ironcalc diverge #NAME?
hyperformula diverge #NAME?
libreoffice diverge
formulas diverge {2025, 03, 01}
pycel diverge #NAME?