BASE64_DECODE
"SGVsbG8gV29ybGQ="
"Hello World"
"###"
null
BYTES_SUBSTRING
"Hello World"
0
10
"Hello Worl"
"Hello World"
1
10
"ello Worl"
"⻤Hello Wor⻤"
1
10
"Hello W"
"⻤Hello Wor⻤"
0
10
"⻤Hello W"
"Hello"
0
10
"Hello"
JOIN_ARRAYS
{n}
prints the nth input. '{0}.{0}.{1}'
on the inputs 'a'
and 'b'
will result in the string 'a.a.b'
MD5
"hello world"
"5eb63bbbe01eeed093cb22bb8f5acdc3"
PRESTO_SPLIT
PRESTO_SPLIT(STRING,DELIMITER)
STRING
A sequence of characters. DELIMITER
A sequence of one or more characters for specifying the boundary between
separate, independent regions in plain text.REGEX
"abcijefjabc"
"abc"
"abc"
, "abc"
REGEX_MATCH_POSITION
REGEX_NAMED_GROUPS
"https://www.domain.com/
page.html"
"^(?:(?<scheme>.*?):\/)?\/?
(?<domain>[^:\/\s]+)
(?::(?<port>\d*))?(?:(\/\w+)*\/)
(?<page>[\w\-\.]+[^#?\s]+)
(?:.*)?quot;
false
false
{"scheme":
"https",
"domain":
"www.domain.com",
"page":
"page.html"}
"http://www.domain.com:
8080/page.html"
"^(?:(?<scheme>.*?):\/)?\/?
(?<domain>[^:\/\s]+)
(?::(?<port>\d*))?(?:(\/\w+)*\/)
(?<page>[\w\-\.]+[^#?\s]+)
(?:.*)?quot;
false
false
{"scheme":
"http",
"domain":
"www.domain.com",
"port":
"8080",
"page":
"page.html"}
"123"
"^(?<digits>\d*)quot;
false
false
{"digits":
"123"}
"foo"
"^(?<digits>\d*)quot;
false
false
null
""
"^(?<digits>\d*)quot;
false
false
{"digits": ""}
""
"^(?<digits>\d*)quot;
false
true
null
"www.upsolver.com"
"\bwww.(?<domain>[^\.]*).com\b"
true
false
{"domain":
"upsolver"}
"www.a.com www.b.com"
"\bwww.(?<domain>[^\.]*).com\b"
true
false
{"domain": "a"}
, {"domain": "b"}
"www.a.com www.b.com"
"\bwww.(?<domain>[^\.]*).com\b"
false
false
{"domain": "a"}
REPLACE
"Hello World"
"Hello"
null
" World"
"Hello World"
"Hello"
"foo"
"foo World"
"World"
"Hello"
"foo"
"World"
SHA1
"hello world"
"2aae6c35c94fcfb415dbe95f408b9ce91ee846ed"
SHA256
"Hello SHA"
"4ea3b17f15346417f4c9b2ff94a1bfe82de99fdb0bbd30dc4dca031ab920d5e4"
SPLIT
SPLIT_DELIMITER_FIRST
SPLIT_DELIMITER_FIRST(DELIMITER, STRING)
DELIMITER
A sequence of one or more characters for specifying the boundary between
separate, independent regions in plain text. STRING
A sequence of characters. ","
"a,b,c,d"
"a"
, "b"
, "c"
, "d"
","
"a"
, "b"
"a"
, "b"
","
",a,b,"
"a"
, "b"
"~~"
"~~a~~b~~"
"a"
, "b"
SPLIT_TO_RECORD
"1,2,3,4"
"a,b,c"
","
false
{"a": "1", "b": "2", "c": "3"}
"1,2"
"a,b,c"
","
false
{"a": "1", "b": "2", "c": ""}
"1,,3"
"a,b,c"
","
true
{"a": "1", "c": "3"}
STRING_FORMAT
{n}
prints the nth input. '{0}.{0}.{1}
' on the inputs 'a'
and 'b'
will result in the string 'a.a.b'
"a"
, "b"
, "c"
"{0} {1} {2}"
"a b c"
1.23
"{0}"
"1.23"
0.5
"{0,number,percent}"
"50%"
1.23
"{0,number,#.###}"
"1.235"
1.2
"{0,number,#.###}"
"1.2"
1.23
"{0,number,0.000}"
"1.235"
1.2
"{0,number,0.000}"
"1.200"
1.23E8
"{0,number,###,###.###}"
"123,456,789.012"
1.23E8
"{0,number,000,000.000}"
"123,456,789.012"
STRING_LENGTH
""
0
"Hello"
5
STRIP_MARGIN
"Hello
∣ World"
"∣"
"Hello
World"
STRIP_PREFIX
"((foo))"
"("
"(foo))"
"foo"
"("
"foo"
STRIP_SUFFIX
"((foo))"
")"
"((foo)"
"foo"
")"
"foo"
SUBSTRING
"Hello World"
0
5
"Hello"
"Hello"
0
-1
"Hello"
"Hello"
1
3
"el"
"Hello"
6
-1
""
"Hello"
-3
-2
"ll"
TOP_PRIVATE_DOMAIN
"www.example.com"
"example.com"
"www.example.co.uk"
"example.co.uk"
"www.example.uk.com"
"example.uk.com"
TO_LOWER
"HELLO world"
"hello world"
TO_UPPER
"HELLO world"
"HELLO WORLD"
TRANSLATE
"a"
"a,Antman
b,Batman
d,"
false
false
"Antman"
"b"
"a,Antman
b,Batman
d,"
false
false
"Batman"
"c"
"a,Antman
b,Batman
d,"
false
false
null
"c"
"a,Antman
b,Batman
d,"
true
false
"c"
"d"
"a,Antman
b,Batman
d,"
true
true
null
"d"
"a,Antman
b,Batman
d,"
true
false
""
1234
"1234.0,good"
false
false
"good"
1234
"1234.0,good"
false
false
"good"
0
"0.0,good"
false
false
"good"
0
"-0.0,good"
false
false
"good"
0
"-0.0,good"
false
false
"good"
123456000000000000
"1.23456e17,good"
false
false
"good"
6
"6.000000000000001,good"
false
false
null
TRIM
"foo"
"foo"
" foo"
"foo"
"foo "
"foo"
" foo "
"foo"
TRIM_CHARS
"-==--Hello World---=---"
"-="
"Hello World"
""
"-"
""
"-----------"
"-"
""
"x-----------"
"-"
"x"
"-----------x"
"-"
"x"
"------x-----"
"-"
"x"
"x-----------x"
"-"
"x-----------x"
URL_DECODE
"The+quick+brown+fox"
"The quick brown fox"
"Comment+%235"
"Comment #5"
URL_ENCODE
"The quick brown fox"
"The+quick+brown+fox"
"Comment #5"
"Comment+%235"
URL_PARSER
UUID_GENERATOR