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]+)

(?:.*)?$"

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]+)

(?:.*)?$"

false

{"scheme":

"http",

"domain":

"www.domain.com",

"port":

"8080",

"page":

"page.html"}

"123"

"^(?<digits>\d*)$"

false

{"digits":

"123"}

"foo"

"^(?<digits>\d*)$"

false

null

""

"^(?<digits>\d*)$"

false

{"digits": ""}

""

"^(?<digits>\d*)$"

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

{"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"

`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"

`STRPOS`

Returns the starting position of the first instance of a given substring within a string.

Syntax

STRPOS(STRING, SUBSTRING)

Arguments

STRING The sequence of characters to search.

SUBSTRING The substring to search for.

Returns

Returns the starting position of the first instance of SUBSTRING in STRING. Positions start from 1. If no instance is found, 0 is returned.

Examples

STRING SUBSTRING Output

STRING	SUBSTRING	Output
All happy families are alike	all	0
All happy families are alike	All	1
All happy families are alike	are	20
All happy families are alike	`''`	1
`''`	`''`	1
`''`	word	0
`null`	word	`null`

All happy families are alike

all

All happy families are alike

All

All happy families are alike

are

All happy families are alike

''

word

null

word

null

`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"

0

-1

"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

"Antman"

"b"

"a,Antman b,Batman d,"

false

"Batman"

"c"

"a,Antman b,Batman d,"

false

null

"c"

"a,Antman b,Batman d,"

true

false

"c"

"d"

"a,Antman b,Batman d,"

true

null

"d"

"a,Antman b,Batman d,"

true

false

""

1234

"1234.0,good"

false

"good"

1234

"1234.0,good"

false

"good"

0

"0.0,good"

false

"good"

0

"-0.0,good"

false

"good"

0

"-0.0,good"

false

"good"

123456000000000000

"1.23456e17,good"

false

"good"

6

"6.000000000000001,good"

false

null

`TRIM`

Returns the given string without leading or trailing whitespaces.

input

result

"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:pass@www.domain.com:80/page.html?query#fragment"

{"scheme": "https", "user_info": "user:pass", "authority": "user:pass@www.domain.com:80", "host": "www.domain.com", "port": 80, "path": "/page.html", "query": "query", "fragment": "fragment"}

"user:pass@www.domain.com/page.html?query"

{"user_info": "user:pass", "authority": "user:pass@www.domain.com", "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

PreviousSpatial functions NextStructural functions

Last updated 9 months ago