1package sheet23import "testing"45func TestSplitAndRegex(t *testing.T) {6 checkArrays(t, fixture(t), []arrCase{7 {`=SPLIT("a,b,,c", ",")`, []string{"a|b|c"}},8 {`=SPLIT("a,b,,c", ",", TRUE, FALSE)`, []string{"a|b||c"}},9 {`=SPLIT("a-b c", "- ")`, []string{"a|b|c"}},10 {`=SPLIT("a--b", "--", FALSE)`, []string{"a|b"}},11 {`=SPLIT("1,2", ",")`, []string{"1|2"}},12 {`=SUM(SPLIT("1,2", ","))`, []string{"3"}},13 {`=SPLIT("abc", "")`, []string{"#VALUE!"}},14 {`=ARRAYFORMULA(SPLIT({"a b";"c d e"}, " "))`, []string{"a|b|", "c|d|e"}},15 {`=REGEXMATCH("order 42", "[0-9]+")`, []string{"TRUE"}},16 {`=REGEXMATCH("order", "^[0-9]+$")`, []string{"FALSE"}},17 {`=REGEXMATCH(42, "4")`, []string{"#VALUE!"}},18 {`=REGEXMATCH("a", "(")`, []string{"#VALUE!"}},19 {`=REGEXEXTRACT("order 42", "[0-9]+")`, []string{"42"}},20 {`=REGEXEXTRACT("key=val", "(\w+)=(\w+)")`, []string{"key|val"}},21 {`=REGEXEXTRACT("key=val", "=(\w+)")`, []string{"val"}},22 {`=REGEXEXTRACT("abc", "[0-9]")`, []string{"#N/A"}},23 {`=REGEXREPLACE("2026-09-27", "(\d+)-(\d+)-(\d+)", "$3/$2/$1")`, []string{"27/09/2026"}},24 {`=REGEXREPLACE("a b", " +", " ")`, []string{"a b"}},25 {`=ARRAYFORMULA(REGEXMATCH(D1:D3, "an"))`, []string{"FALSE", "TRUE", "FALSE"}},26 {`=FILTER(D1:D5, REGEXMATCH(D1:D5, "^A"))`, []string{"Apple", "Apple"}},27 })28}