DV-0208
lattice: different argument interpretation — REGEXEXTRACT
Subjects (1)
Tests (1)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
REGEXEXTRACT/extract-case-insensitive-via-4th-arg |
{"excel":"=REGEXEXTRACT(\"ITEM: ABC123\", \"item: ([A-Z]+\\d+)\", 0, 1)","lattice":"=REGEXEXTRACT(\"ITEM: ABC123\", \"item: ([A-Z]+\\d+)\", 0, 1)"} |
ITEM: ABC123 | gsheets— | excelITEM: ABC123 | latticeABC123 | ironcalc— | hyperformula— | libreoffice— | formulas— | pycel— |