Upsolver
Search…
String functions
This page goes over the string functions in Upsolver.

BASE64_DECODE

Decode a base 64 string into a string.
value
result
"SGVsbG8gV29ybGQ="
"Hello World"
"###"
null

BYTES_SUBSTRING

Returns a substring of the input, using the offsets in bytes of the UTF-8 encoded byte representation. Partial characters and invalid UTF-8 code points are removed from the result.

Inputs

  • value - Value to substring

Properties

  • Start Index - The inclusive start index in bytes
  • End Index - The exclusive end index in bytes
value
Start Index
End Index
result
"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

Joins any number of arrays by index using a MessageFormat pattern.

Properties

  • Format String - The format string where {n} prints the nth input.
    • For example, the pattern '{0}.{0}.{1}' on the inputs 'a' and 'b' will result in the string 'a.a.b'

MD5

Hashes the input using MD5.
input
result
"hello world"
"5eb63bbbe01eeed093cb22bb8f5acdc3"

PRESTO_SPLIT

This function returns the given string split by the provided delimiter.

Syntax

PRESTO_SPLIT(STRING,DELIMITER)

Arguments

STRING A sequence of characters.
DELIMITER A sequence of one or more characters for specifying the boundary between separate, independent regions in plain text.

Returns

The given string split by the provided delimiter.

Examples

String
Delimiter
Result
'a""b'
'"'
"a", , "b"
'-a-bc-d-'
'-'
, "a", "bc", "d",
"~~a~~b~~"
"~~"
, "a", "b",
'Abra&Cadabra'
'&'
"Abra", "Cadabra"

REGEX

Matches the regular expression on the input string. Returns the escape groups if any exists or the original string if none exists.

Properties

  • Pattern - Regular Expression Pattern
input
Pattern
result
"abcijefjabc"
"abc"
"abc", "abc"

REGEX_MATCH_POSITION

Matches the regular expression on the input string and returns the index of the first match.

Inputs

  • value
  • startPosition

Properties

  • Pattern - Pattern to search for

REGEX_NAMED_GROUPS

Matches the regular expression on the input string. Returns record with field names and group names.

Properties

  • Pattern - Regular Expression Pattern
  • All Matches - Return all the matches of the pattern, and not only the first one
  • Filter Empty - Filter out empty matches
input
Pattern
All Matches
Filter Empty
result
"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

Replace substrings within a string.

Properties

  • Pattern - Pattern to replace (regex)
  • Replacement - Replacement string
value
Pattern
Replacement
result
"Hello World"
"Hello"
null
" World"
"Hello World"
"Hello"
"foo"
"foo World"
"World"
"Hello"
"foo"
"World"

SHA1

Hashes the input using SHA-1.
input
result
"hello world"
"2aae6c35c94fcfb415dbe95f408b9ce91ee846ed"

SHA256

Hashes the input using SHA-256.
input
result
"Hello SHA"
"4ea3b17f15346417f4c9b2ff94a1bfe82de99fdb0bbd30dc4dca031ab920d5e4"

SPLIT

Returns an error message indicating that SPLIT has been deprecated.

SPLIT_DELIMITER_FIRST

Returns the given string split by the provided delimiter.

Syntax

SPLIT_DELIMITER_FIRST(DELIMITER, STRING)

Arguments

DELIMITER A sequence of one or more characters for specifying the boundary between separate, independent regions in plain text.
STRING A sequence of characters.

Returns

The given string split by the provided delimiter.

Examples

Delimiter
Input String
Result
","
"a,b,c,d"
"a", "b", "c", "d"
","
"a", "b"
"a", "b"
","
",a,b,"
"a", "b"
"~~"
"~~a~~b~~"
"a", "b"

SPLIT_TO_RECORD

Returns the given string split by the provided delimiter.

Properties

  • Field Names
  • Delimiter
  • Filter Empty Values
value
Field Names
Delimiter
Filter Empty Values
result
"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

Format any number of inputs into a string using the given format.

Properties

  • Format String - The format string where {n} prints the nth input.
    • For example, the pattern '{0}.{0}.{1}' on the inputs 'a' and 'b' will result in the string 'a.a.b'
inputs
Format String
result
"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

Gets the length of the string.
input
result
""
0
"Hello"
5

STRIP_MARGIN

For each line remove prefix of control or whitespace characters followed by the given margin char.

Properties

  • Margin Char
input
Margin Char
result
"Hello ∣ World"
"∣"
"Hello World"

STRIP_PREFIX

Remove the given prefix string from the beginning of the string.

Properties

  • Prefix
input
Prefix
result
"((foo))"
"("
"(foo))"
"foo"
"("
"foo"

STRIP_SUFFIX

Remove the given suffix string from the end of the string.

Properties

  • Suffix
input
Suffix
result
"((foo))"
")"
"((foo)"
"foo"
")"
"foo"

SUBSTRING

Returns a string that is a substring of the given string.

Inputs

  • value
  • startPosition
  • endPosition
value
startPosition
endPosition
result
"Hello World"
0
5
"Hello"
"Hello"
0
-1
"Hello"
"Hello"
1
3
"el"
"Hello"
6
-1
""
"Hello"
-3
-2
"ll"

TOP_PRIVATE_DOMAIN

Get the top private domain from a domain name.
value
result
"www.example.com"
"example.com"
"www.example.co.uk"
"example.co.uk"
"www.example.uk.com"
"example.uk.com"

TO_LOWER

Converts the string to lowercase letters.
input
result
"HELLO world"
"hello world"

TO_UPPER

Converts the string to uppercase letters.
input
result
"HELLO world"
"HELLO WORLD"

TRANSLATE

Translates the given value using a given dictionary.

Properties

  • Dictionary
  • Keep Values Without Translation - Whether to keep values that have that are not mapped to a value in the feature
  • Empty As Null - If set, empty values will be treated as null
input
Dictionary
Keep Values Without Translation
Empty As Null
result
"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

Returns the given string without leading or trailing whitespaces.
input
result
"foo"
"foo"
" foo"
"foo"
"foo "
"foo"
" foo "
"foo"

TRIM_CHARS

Returns the given string without leading or trailing characters.

Properties

  • Characters
input
Characters
result
"-==--Hello World---=---"
"-="
"Hello World"
""
"-"
""
"-----------"
"-"
""
"x-----------"
"-"
"x"
"-----------x"
"-"
"x"
"------x-----"
"-"
"x"
"x-----------x"
"-"
"x-----------x"

URL_DECODE

Decode url encoded text.
input
result
"The+quick+brown+fox"
"The quick brown fox"
"Comment+%235"
"Comment #5"

URL_ENCODE

Encode text to url encoded format.
input
result
"The quick brown fox"
"The+quick+brown+fox"
"Comment #5"
"Comment+%235"

URL_PARSER

Parses the URI/URL into its component parts.
value
result
"https://www.domain.com/page.html"
{"scheme": "https", "authority": "www.domain.com", "host": "www.domain.com", "path": "/page.html"}
"https://user:[email protected]:80/page.html?query#fragment"
{"scheme": "https", "user_info": "user:pass", "authority": "user:[email protected]:80", "host": "www.domain.com", "port": 80, "path": "/page.html", "query": "query", "fragment": "fragment"}
"user:[email protected]/page.html?query"
{"user_info": "user:pass", "authority": "user:[email protected]", "host": "www.domain.com", "path": "/page.html", "query": "query"}
"www.domain.com/page.html#fragment"
{"authority": "www.domain.com", "host": "www.domain.com", "path": "/page.html", "fragment": "fragment"}
"/www.domain.com"
{"path": "/www.domain.com"}

UUID_GENERATOR

Returns UUID.

Inputs

  • hash - Value for extra randomness