assay
regex

extract-capture-groups-when-multiple-groups-present

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

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets diverge {[object Object], [object Object], [object Object]}
excel diverge [object Object]
lattice diverge {2025, 03, 01}
ironcalc diverge #NAME?
hyperformula diverge #NAME?
libreoffice match
formulas diverge 2025-03-01
pycel diverge #NAME?