08b0c4 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"hello world\", \"world\")","excel":"=REGEXTEST(\"hello world\", \"world\")","lattice":"=REGEXMATCH(\"hello world\", \"world\")"} |
value |
|
885d38 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"hello\", \"xyz\")","excel":"=REGEXTEST(\"hello\", \"xyz\")","lattice":"=REGEXMATCH(\"hello\", \"xyz\")"} |
value |
|
f4846a |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"hello\", \"^hello$\")","excel":"=REGEXTEST(\"hello\", \"^hello$\")","lattice":"=REGEXMATCH(\"hello\", \"^hello$\")"} |
value |
|
3a4b2c |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"hello world\", \"^hello$\")","excel":"=REGEXTEST(\"hello world\", \"^hello$\")","lattice":"=REGEXMATCH(\"hello world\", \"^hello$\")"} |
value |
|
8f8794 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"hello\", \"^hel\")","excel":"=REGEXTEST(\"hello\", \"^hel\")","lattice":"=REGEXMATCH(\"hello\", \"^hel\")"} |
value |
|
14f1e2 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"hello\", \"llo$\")","excel":"=REGEXTEST(\"hello\", \"llo$\")","lattice":"=REGEXMATCH(\"hello\", \"llo$\")"} |
value |
|
7b1611 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"abc 123\", \"\\d+\")","excel":"=REGEXTEST(\"abc 123\", \"\\d+\")","lattice":"=REGEXMATCH(\"abc 123\", \"\\d+\")"} |
value |
|
230f0f |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"abc\", \"\\d+\")","excel":"=REGEXTEST(\"abc\", \"\\d+\")","lattice":"=REGEXMATCH(\"abc\", \"\\d+\")"} |
value |
|
1ddd88 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"hello_world\", \"\\w+\")","excel":"=REGEXTEST(\"hello_world\", \"\\w+\")","lattice":"=REGEXMATCH(\"hello_world\", \"\\w+\")"} |
value |
|
7bdcfc |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"hello\", \"[a-z]+\")","excel":"=REGEXTEST(\"hello\", \"[a-z]+\")","lattice":"=REGEXMATCH(\"hello\", \"[a-z]+\")"} |
value |
|
c18550 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"HELLO\", \"[a-z]+\")","excel":"=REGEXTEST(\"HELLO\", \"[a-z]+\")","lattice":"=REGEXMATCH(\"HELLO\", \"[a-z]+\")"} |
value |
|
7b21ae |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"abc123\", \"[a-z]{3}\\d{3}\")","excel":"=REGEXTEST(\"abc123\", \"[a-z]{3}\\d{3}\")","lattice":"=REGEXMATCH(\"abc123\", \"[a-z]{3}\\d{3}\")"} |
value |
|
5b498a |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"aab\", \"a{2,3}b\")","excel":"=REGEXTEST(\"aab\", \"a{2,3}b\")","lattice":"=REGEXMATCH(\"aab\", \"a{2,3}b\")"} |
value |
|
10315e |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"ab\", \"a{2,3}b\")","excel":"=REGEXTEST(\"ab\", \"a{2,3}b\")","lattice":"=REGEXMATCH(\"ab\", \"a{2,3}b\")"} |
value |
|
e30d05 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"cat\", \"cat|dog\")","excel":"=REGEXTEST(\"cat\", \"cat|dog\")","lattice":"=REGEXMATCH(\"cat\", \"cat|dog\")"} |
value |
|
48671b |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"dog\", \"cat|dog\")","excel":"=REGEXTEST(\"dog\", \"cat|dog\")","lattice":"=REGEXMATCH(\"dog\", \"cat|dog\")"} |
value |
|
b499f2 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"fish\", \"cat|dog\")","excel":"=REGEXTEST(\"fish\", \"cat|dog\")","lattice":"=REGEXMATCH(\"fish\", \"cat|dog\")"} |
value |
|
9c4d8b |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"hello world\", \"\\bworld\\b\")","excel":"=REGEXTEST(\"hello world\", \"\\bworld\\b\")","lattice":"=REGEXMATCH(\"hello world\", \"\\bworld\\b\")"} |
value |
|
b28227 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"helloworld\", \"\\bworld\\b\")","excel":"=REGEXTEST(\"helloworld\", \"\\bworld\\b\")","lattice":"=REGEXMATCH(\"helloworld\", \"\\bworld\\b\")"} |
value |
|
dd4e97 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"HELLO\", \"hello\")","excel":"=REGEXTEST(\"HELLO\", \"hello\")","lattice":"=REGEXMATCH(\"HELLO\", \"hello\")"} |
value |
|
0779a6 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"HELLO\", \"(?i)hello\")","excel":"=REGEXTEST(\"HELLO\", \"(?i)hello\")","lattice":"=REGEXMATCH(\"HELLO\", \"(?i)hello\")"} |
value |
|
e61117 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"café\", \"\\p{L}+\")","excel":"=REGEXTEST(\"café\", \"\\p{L}+\")","lattice":"=REGEXMATCH(\"café\", \"\\p{L}+\")"} |
value |
1 |
eb4ae5 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"123\", \"\\p{L}\")","excel":"=REGEXTEST(\"123\", \"\\p{L}\")","lattice":"=REGEXMATCH(\"123\", \"\\p{L}\")"} |
value |
1 |
7b7dc4 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"你好世界\", \"\\p{L}+\")","excel":"=REGEXTEST(\"你好世界\", \"\\p{L}+\")","lattice":"=REGEXMATCH(\"你好世界\", \"\\p{L}+\")"} |
value |
1 |
44c9d5 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"Ångström\", \"Å\")","excel":"=REGEXTEST(\"Ångström\", \"Å\")","lattice":"=REGEXMATCH(\"Ångström\", \"Å\")"} |
value |
|
52c278 |
REGEXEXTRACT |
=REGEXEXTRACT("résumé template", "résumé") |
value |
|
a8fa6d |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"CAFÉ\", \"(?i)café\")","excel":"=REGEXTEST(\"CAFÉ\", \"(?i)café\")","lattice":"=REGEXMATCH(\"CAFÉ\", \"(?i)café\")"} |
value |
|
2b17f3 |
REGEXEXTRACT |
=REGEXEXTRACT("abc 123 def", "\d+") |
value |
|
e1c7a2 |
REGEXEXTRACT |
=REGEXEXTRACT("Price: $100", "\$\d+") |
value |
|
44cf19 |
REGEXEXTRACT |
=REGEXEXTRACT("one 1 two 2 three 3", "\d+") |
value |
|
4ebaa3 |
REGEXEXTRACT |
=REGEXEXTRACT("Price: $100", "\$(\d+)") |
value |
|
77add2 |
REGEXEXTRACT |
=REGEXEXTRACT("2025-03-01", "(\d{4})-(\d{2})-(\d{2})") |
value |
|
d389f9 |
REGEXEXTRACT |
=REGEXEXTRACT("foo bar baz", "(\w+)\s+(\w+)") |
value |
|
149bd7 |
REGEXEXTRACT |
=REGEXEXTRACT("hello", "\d+") |
value |
|
f46e7c |
REGEXEXTRACT |
=REGEXEXTRACT("", "\d+") |
value |
|
f846c2 |
REGEXEXTRACT |
=REGEXEXTRACT("Hello World", "(?i)(\w+)") |
value |
|
725906 |
REGEXEXTRACT |
=REGEXEXTRACT("a1 b2 c3", "\d+", 1) |
value |
1 |
7d98d3 |
REGEXEXTRACT |
=REGEXEXTRACT("2025-03-01", "(\d{4})-(\d{2})-(\d{2})", 2) |
value |
1 |
515e76 |
REGEXREPLACE |
=REGEXREPLACE("a1b2c3", "\d", "x") |
value |
|
472840 |
REGEXREPLACE |
=REGEXREPLACE("aabbaa", "a+", "x") |
value |
|
320388 |
REGEXREPLACE |
=REGEXREPLACE("hello world", "\s+", "-") |
value |
|
8ed6cd |
REGEXREPLACE |
=REGEXREPLACE("hello", "\d+", "x") |
value |
|
c1b597 |
REGEXREPLACE |
=REGEXREPLACE("", "\d+", "x") |
value |
|
702b5d |
REGEXREPLACE |
=REGEXREPLACE("hello world", "(\w+)", "[$1]") |
value |
|
8d0a25 |
REGEXREPLACE |
=REGEXREPLACE("John Smith", "(\w+) (\w+)", "$2, $1") |
value |
|
760297 |
REGEXREPLACE |
=REGEXREPLACE("2025-03-01", "(\d+)-(\d+)-(\d+)", "$3/$2/$1") |
value |
|
9760ee |
REGEXREPLACE |
{"excel":"=REGEXREPLACE(\"aabbaa\", \"a+\", \"x\", 1)","lattice":"=REGEXREPLACE(\"aabbaa\", \"a+\", \"x\", 1)"} |
value |
|
d41b84 |
REGEXREPLACE |
{"excel":"=REGEXREPLACE(\"aabbaa\", \"a+\", \"x\", -1)","lattice":"=REGEXREPLACE(\"aabbaa\", \"a+\", \"x\", -1)"} |
value |
|
034f7d |
REGEXREPLACE |
{"excel":"=REGEXREPLACE(\"a1 a2 a3\", \"a\\d\", \"x\", 2)","lattice":"=REGEXREPLACE(\"a1 a2 a3\", \"a\\d\", \"x\", 2)"} |
value |
|
8e8e02 |
REGEXREPLACE |
{"excel":"=REGEXREPLACE(\"Hello WORLD hello\", \"hello\", \"hi\", 0, 1)","lattice":"=REGEXREPLACE(\"Hello WORLD hello\", \"hello\", \"hi\", 0, 1)"} |
value |
|
dfbbcf |
REGEXEXTRACT |
{"excel":"=REGEXEXTRACT(\"ITEM: ABC123\", \"item: ([A-Z]+\\d+)\", 0, 1)","lattice":"=REGEXEXTRACT(\"ITEM: ABC123\", \"item: ([A-Z]+\\d+)\", 0, 1)"} |
value |
1 |
f86e47 |
REGEXREPLACE |
=REGEXREPLACE("Hello WORLD hello", "(?i)hello", "hi") |
value |
|
9bef7c |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"hello\", \"(?<=hel)lo\")","excel":"=REGEXTEST(\"hello\", \"(?<=hel)lo\")","lattice":"=REGEXMATCH(\"hello\", \"(?<=hel)lo\")"} |
value |
1 |
119bb9 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"foobar\", \"foo(?=bar)\")","excel":"=REGEXTEST(\"foobar\", \"foo(?=bar)\")","lattice":"=REGEXMATCH(\"foobar\", \"foo(?=bar)\")"} |
value |
1 |
484c40 |
REGEXMATCH |
{"gsheets":"=REGEXMATCH(\"foobar\", \"foo(?!baz)\")","excel":"=REGEXTEST(\"foobar\", \"foo(?!baz)\")","lattice":"=REGEXMATCH(\"foobar\", \"foo(?!baz)\")"} |
value |
1 |