assay
text-longtail

split-empty-tokens

Subject
SPLIT
Category
value
Formula
=SPLIT("a,,b", ",", TRUE, FALSE)
Canonical
{a, , b}

Owning divergences (2)

Per-engine results

matches canonical diverges no fixture

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