All pages
Powered by GitBook
1 of 44

Text

AsText

The AsText() returns a rich text as plain text, including all HTML tags as normal and visible text.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a text that includes all HTML tags as normal text. Returns Invalid expression if one of the parameter values is unknown, or when the input text is not a rich text.

Syntax

AsText(text)

AsText(RichText("<html><body>Welcome</body></html>")) => "<html><body>Welcome</body></html>"

AsText("Welcome") => "Welcome"

AsText() => Invalid expression

Parameters

Name
Type
Required
Description

text

text

☑️

a HTML text

Base32ToText

The Base32ToText() function decodes a base32 encoded string to a text value. Decoding is carried out using the UTF8 charset.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a base32 decoded text. Returns [no value]if one of the parameter values is unknown or not base32 encoded.

Syntax

Base32ToText(text)

Base32ToText("JBSWY3DPEBLUKTJB")

Returns Hello WEM!

Base64ToText([simple text not base32])

Returns [no value]

Parameters

Name
Type
Required
Description

text

text

☑️

a base32 encoded text

Base64ToText

The Base64ToText() function decodes a base64 encoded string to a text value. Decoding is carried out using the UTF8 charset.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a base64 decoded text Returns Invalid expressionif one of the parameter values is unknown.

Syntax

Base64ToText(text)

Base64ToText("SGVsbG8gd29ybGQ=") => "Hello world"

Base64ToText([simple tekst not base64]) => Invalid expression

Parameters

Name
Type
Required
Description

text

text

☑️

a base64 encoded text

CompareFuzzy

The CompareFuzzy() function compares two texts and returns a number between 0 and 1 (inclusive) that indicates the similarity between the two texts. 0 being totally different (0% match) and 1 being exactly the same (100% match).

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a number that indicates the similarity of text1 and text2, where a number close to 1 means very similar and a number close to 0 means very different. Returns Invalid expressionif one of the parameter values is unknown.

Syntax

CompareFuzzy(text1, text2)

CompareFuzzy("are you good?", "are you god?") => 0.9166666667

CompareFuzzy("Geneva", "Genèva") => 1

Parameters

Name
Type
Required
Description

text1

text

☑️

the first text to compare.

text2

text

☑️

the second text to compare.

Concat

The Concat() function strings together a list of texts.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text that consists of the given values that are all concatenated. Returns Invalid expression if one of the parameter values is unknown or outside the common valid boundaries.

Syntax

Concat(values)

Concat("text1", "text2") => "text1text2"

Concat(values, delimiter)

Concat(List("text1", "textpart2", "listitem3"), "#SEP#") => "text1#SEP#textpart2#SEP#listitem3"

Concat(values, delimiter, last_delimiter)

Concat(List("text1", "textpart2", "listitem3"), "#SEP#", "$LAST$") => "text1#SEP#textpart2$LAST$listitem3"

Parameters

Name
Type
Required
Description

values

text or list

☑️

a list of text

delimiter

text

is placed between the parts when they are joined together.

last_delimiter

text

is placed between the last two parts.

Contains

This function is only available for backwards compatibility.

The Contains Keyword is the preferred option: it can be used on Texts, on Concept Sets and on Lists.

Check the page for the Contains keyword.

The Contains() function checks if a string contains another string. This check is not case-sensitive and ignores diacritics.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns true if text contains subtext and false otherwise

Syntax

Contains(text,subtext)

Contains("Text contains subtext", "contains") => True

Contains("Text contains subtext", " spaces ") => False

Parameters

Name
Type
Required
Description

text

text

☑️

Original text you want to check.

subtext

text

☑️

Text that you check the original text for.

FormatDate

The FormatDate() function converts a date to a specified format.

Typical elements that can be used in the date format: yyyy: full year; MM: month number with leading zero; dd: day-number with leading zero; HH: 24-hour time with leading zero; h: 12-hour time without leading zero; mm: minutes with leading zero; ss: seconds with leading zero; fff: fraction of a second (milliseconds in this case).

See the [Microsoft documentation] (https://msdn.microsoft.com/en-us/library/8kb3ddd4(v=vs.110).aspx) to learn more about format strings.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text string that is the text representation of a date. Returns Invalid expression if Dateis unknown or the indicated format is not valid for dates.

Syntax

FormatDate(date,format)

FormatDate(Now(), "MM-dd-yyyy") => "05-13-2022"

FormatDate(date,language)

FormatDate(Now(), en_US) => "5/13/2022 01:54:00 PM"

Parameters

Name
Type
Required
Description

date

date time

☑️

a date

format

text or formatstring

☑️

the format is used to specify how the date should be represented, text or a format string can be used.

language

text

☑️

this parameter is used to specify the date representation of that language

Format strings

Format name
Example
Description

ShortDate

8-4-2022

day month and year in numbers.

ShortDateTime

8-4-2022 17:51

day, month, year and time in numbers

LongDate

vrijdag 8 april 2022

day of the week and month in text with the day and year in numbers.

LongDateTime

vrijdag 8 april 2022 17:51

day of the week and month in text with the day, year and time in numbers.

Iso8601

2022-04-08T17:51:38

date in the iso8601 standard

When using a format string, the separator and order of your date is dependent on your date settings. You can find and change this setting per portal, see more about portal and language settings here.

If the format or language parameter contains an unknown value, then the default portal language is used to format the string.

FormatDuration

The Formatduration() function converts a duration to text according to the provided format.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text string that is the text representation of a duration. Returns Invalid expression ifnumberis unknown or the indicated format is not valid for duration.

Syntax

FormatDuration(duration,format)

FormatDuration('3d4h17m30s', "hh") => 04

FormatDuration(duration,language)

FormatDuration('2d3h21m54.87s', currentlanguage) => 02:03:21:54.87

Parameters

Name
Type
Required
Description

duration

date time

☑️

a duration, in minutes, hours or seconds.

format

numeric

☑️

the format is used to specify how the duration should be represented. You can find the different formats below.

language

yes/no

☑️

this parameter is used to specify the time representation of that language. If the language parameter contains an unknown value, the default portal language is used to format the duration.

The format parameter can contain a number of WEM specific options:

  • days - returns the total number of days in the duration

  • hours- returns the total number of hours in the duration

  • minutes - returns the total number of minutes in the duration

  • seconds - returns the total number of seconds in the duration

  • long - returns the duration as a written string, based on the portal language

  • stopwatch - returns the duration formatted as follows: (hours):(minutes):(seconds)

  • clock - returns the duration formatted as follows: (hours):(minutes)

You can also use the [Microsoft format strings](https://msdn.microsoft.com/en-us/library/ee372287(v=vs.110).aspx ) to format the duration.

FormatNumber

The FormatNumber() function converts a number to text according to the specified format.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text string that is the formatted text representation of a number. Returns Invalid expression if numberis unknown or the indicated format is not valid for numeric values.

Syntax

FormatNumber(number,decimals,language)

FormatNumber(123456.789, 2) => 123456,78 (when the currentlanguage has the comma for decimal point)

FormatNumber(123456.789, 2, en_US) => 123456.78

FormatNumber(number,decimals,grouping,language)

FormatNumber(123456.789, 2, true) => 123.456,78 (when the currentlanguage has the comma for decimal point)

FormatNumber(123456.789, 2, true, en_US) => 123,456.78

Parameters

Name
Type
Required
Description

number

numeric

☑️

a value of any type.

decimals

numeric

☑️

the number of decimals that are included in the returned text

grouping

yes/no

☑️

a boolean that indicates if large numbers are grouped (a separator is used)

language

language keyword

this parameter is used to specify the number representation according to the specified language/culture.

If the language parameter is not specified or contains an unknown value, then the default portal language is used to format the number.

Guid

The Guid() function generates a Globally Unique Identifier (GUID).

See wikipedia to learn more about GUIDs.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a text that contains a GUID (Global Unique Identifier).

Syntax

Guid()

Guid() => "3F2504E0-4F89-41D3-9A0C-0305E82C3301"

HexToText

The HexToText() function converts a hexadecimal value to its string equivalent (UTF8).

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a text that is the UTF8 equivalent of the provided hexadecimal input.

Syntax

HexToText(text)

HexToText("71776572747975696f7031323334353637383930") => "qwertyuiop1234567890"

Parameters

Name
Type
Required
Description

text

text

☑️

Original text in hexadecimal form.

HtmlAttributeEncode

The HtmlAttributeEncode() function encodes the given text in a form that can safely be used inside an HTML attribute.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a text that can safely be used inside an Html attribute. Returns Invalid expression if the result is not a text.

Syntax

HtmlAttributeEncode(text)

HtmlAttributeEncode("\"Line 1\"\n'Line 2'") => &quot;Line 1&quot; &#39;Line 2&#39;

HtmlAttributeEncode() => Invalid expression

Parameters

Name
Type
Required
Description

text

text

☑️

a text to be used as an attribute in HTML tags

HtmlEncode

The HtmlEncode() function converts a text to an HTML encoded text.

Wiki: more about Html Encoding

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a HTML encoded text. Returns Invalid expression if the value is unknown.

Syntax

HtmlEncode(text)

HtmlEncode("\"Line 1\"\n'Line 2'")

=> "Line 1" 'Line 2'

Parameters

Name
Type
Required
Description

text

text

☑️

a text string that is used in an HTML element

IndexOf

The IndexOf() function returns the position of a text within another text.

It will return 0 if the searched text was not found.

This function is NOT case-sensitive.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns the position as a numeric value where the searched text is found within the source.

The index of the first character is 1, the second character is 2, etc. (1-based).

Returns 0 if the searched text is not found within the source.

Syntax

IndexOf(source, search)

IndexOf("In this bit of text, we are searching 4 some answers, so where is it?", "searching 4") => 29

Parameters

Name
Type
Required
Description

source

text

☑️

the source in which the function will search for the search text

search

text

☑️

the text to search for

JavascriptEncode

The JavascriptEncode() function encodes the given value to a Javascript literal.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a text that contains a JavaScript literal. Returns null if the value is unknown.

Syntax

JavascriptEncode(value)

JavascriptEncode("\"Line 1\"\n'Line 2';") => "\"Line 1\"\n\'Line 2\';"

Parameters

Name
Type
Required
Description

value

any WEM value

☑️

see hint below

Value - any WEM value (strings, numbers, boolean, etc.). The following encoding is used for non-native JavaScript types:

  • Concept - the concept ID is used

  • Concept set - array of concept ID's is used

  • Duration - the number of ticks (milliseconds) is used

  • File - the URL as a string

  • Reference - string representation of the referenced list and rowID

JsonEncode

The JSONEncode() function encodes the given value to a json literal.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text that contains a JSON literal. Returns null if the value is unknown.

Syntax

JsonEncode(value)

JsonEncode(List(1,2,3)) => [1,2,3]

Parameters

Name
Type
Required
Description

value

text, numeric, yes/no, list

☑️

values of these types can be used.

Length

The Length() function calculates the number of characters of a text.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a number that is the character count of a text. Returns Invalid expression if the result is not a text.

Syntax

Length(text)

Length("SomeText or Other 1234") => 22

Parameters

Name
Type
Required
Description

text

text

☑️

a text

Padl

The Padl() function keeps prepending a single character to a text until a specified length is reached.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text where the indicated character is prepended as many times as necessary until the indicated length is reached. Returns Invalid expression if input values do not match required type.

Syntax

Padl(value, text_length, char)

Padl("forty-two", 15, ".") => "......forty-two"

Padl("forty-two", 15, "WORD") => "WWWWWWforty-two" (only the FIRST character of the prepend text is used!)

Parameters

Name
Type
Required
Description

value

text, numeric

☑️

a text or a number.

length

numeric

☑️

the number of characters in the resulting text.

char

text

☑️

the character to prepend. If this value has more than 1 character, then the

first character is taken.

Padr

The Padr() function keeps appending a single character to a text until a specified length is reached.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text where the indicated character is appended as many times as necessary until the indicated length is reached. Returns Invalid expression if input does not match required type.

Syntax

Padr(value, text_length, char)

Padr("forty-two", 15, ".") => "forty-two......"

Padr("forty-two", 15, "WORD") => "forty-twoWWWWWW"

Parameters

Name
Type
Required
Description

value

text, numeric

☑️

a text or a number.

length

numeric

☑️

the number of characters in the resulting text.

char

text

☑️

the character to append. If this value has more than 1 character, then only the

first character is taken.

RegExIsMatch

The RegExIsMatch() function checks a text for a pattern if it can be found.

All regex functions use a pattern to check for matches in the input text.

For a more complete explanation and special / allowed characters you can visit this WEM Forum post. Here you find a cheat-sheet and a few helpful examples.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns True if the pattern is found in text.

Returns False if the pattern is not found in text.

Returns [unknown] if no matches are found or the pattern is faulty.

Syntax

RegExIsMatch(pattern, Text)

RegExIsMatch("([0-9:]+)", "Yes the match is at 20:15") => True

Parameters

Name
Type
Required
Description

pattern

text

☑️

The pattern you want to check for.

text

text

☑️

The text you want to check for patterns.

RegExMatches

The RegExMatches() checks a text for patterns and returns all matching results.

All regex functions use a pattern to check for matches in the input text.

For a more complete explanation and special / allowed characters you can visit this WEM Forum post. Here you find a cheat-sheet and a few helpful examples.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns an array of all matching values. Returns Invalid expression if no matches are found or the pattern is faulty.

Syntax

RegExMatches(pattern, text)

RegExMatches("\\b\\w+es\\b", "There are matches in this line, but who writes these notes anyway?") => "matches, writes, notes"

Parameters

Name
Type
Required
Description

pattern

text

☑️

The pattern you want to check for.

text

text

☑️

The text you want to check for patterns.

RegExReplace

The RegExReplace() function replaces all matches for Pattern in SourceText, and replaces them with the ReplaceText value.

All regex functions use a pattern to check for matches in the input text.

For a more complete explanation and special / allowed characters you can visit this WEM Forum post. Here you find a cheat-sheet and a few helpful examples.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns SourceText with the matching patterns replaced by the replace-text value.

Returns SourceText if no matches are found or the pattern is faulty.

Syntax

RegExReplace(pattern, sourcetext, replacetext)

RegExReplace("\\d{3}", "Triple (3) numbers like 123 are replaced by zeroes. Some but not all of these 5-niners (99999) become zeroes, and a phonenumber like 020-2402120?", "000") => "Triple (3) numbers like 000 are replaced by zeroes. Some but not all of these 5-niners (00099) become zeroes, and a phonenumber like 000-0000000?"

Parameters

Name
Type
Required
Description

pattern

text

☑️

The pattern you want to replace.

sourcetext

text

☑️

The text you want to check for patterns to replace.

replacetext

text

☑️

The text you want to replace the pattern with.

Replace

The Replace() function returns a new text in which all occurences of old_value in text are replaced by new_value.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text where each occurence of old_value is replaced by new_value. Returns Invalid expression if the result is not a text.

Syntax

Replace(text, old_value, new_value)

Replace("All the 1234 parts will be replaced.", "the 1234", "unknown or illegal") => "All unknown or illegal parts will be replaced."

Parameters

Name
Type
Required
Description

text

text

☑️

the text on which the replace operation is performed.

old_value

text

☑️

the text that is to be replaced by new_value.

new_value

text

☑️

the text that replaces all occurrences of old_value.

Split

The Split() function splits a text into an array of text values.

On an array (like resulting from this split) you can access a specific item by its position in the array, using the (i) (1-based) positioning indicator.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Note: The separatoris case sensitive!

Returns an array of text values split at each point where the separator occurs in the given text. Only segments that have a value are included in the returned array. When a split occurs without a value, it is not included. A space is considered as a value and will be returned as a separate array element. This can be useful for counting the number of separations, for example.

Syntax

Split(text, separator)

Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",") => ("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec")

Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",")(3) => "Mar"

Parameters

Name
Type
Required
Description

text

text

☑️

The text to split.

separator

text

☑️

Specifies the character(s) to use for separating the text.

StringPart

The StringPart() function splits a text into an array of text values, and returns the part at a specified position.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns the part of a text that can be determined by splitting it on the indicated separator and then taking the resulting part at the indicated position. Returns Invalid expression if one of the parameters is not valid.

Syntax

StringPart(text, separator, position)

StringPart("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",", 3) => "Mar"

Parameters

Name
Type
Required
Description

text

text

☑️

The text to split

separator

text

☑️

Specifies the character(s) to use for separating the text

position

text

☑️

The position of the part to return

SubString

The Substring() function returns a subset of a text.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text that is a subset of text beginning at a position through a number of characters. Returns Invalid expression if one of the parameters is not valid.

Syntax

Substring(text,length)

Substring("Important", 6) => "Import"

Substring(text,start_position,length)

Substring("Important", 2, 4) => "port"

Parameters

Name
Type
Required
Description

text

text

☑️

a text

start_position

numeric

(optional) the position to start from

length

numeric

☑️

the number of characters to take from text

ToBase32

The ToBase32() function encodes text to base32 encoded text.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Encoding is carried out using the UTF8 charset.

Returns a base32 encoded text.

If the parameter is not a valid text, unknown is returned.

Syntax

ToBase32(text)

ToBase32("Hello WEM!") => "JBSWY3DPEBLUKTJB"

Parameters

Name
Type
Required
Description

text

text

☑️

a text

ToBase64

The ToBase64() function encodes a text or a file to base64 encoded text.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Encoding is carried out using the UTF8 charset.

Returns a base64 encoded text.

If the parameter is not a valid text or a file, unknown is returned.

Syntax

ToBase64(text)

ToBase64("SomeText or Other 1234") => "U29tZVRleHQgb3IgT3RoZXIgMTIzNA=="

ToBase64(file)

ToBase64([File Field]) => "U29t... all-base64 chars to represent file ... IgT3RoZXI=="

Parameters

Name
Type
Required
Description

text

text

☑️

a text

file

file

☑️

a file

ToBase64Url

The ToBase64Url() function encodes a text or a file to a base64 encoded text which is safe to use in URLs.

WIKI: https://en.wikipedia.org/wiki/Base64#The_URL_applications

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Encoding is carried out using the UTF8 charset.

Returns a base64 encoded text that is safe to use in URLs.

Syntax

ToBase64Url(text)

ToBase64Url("SomeText or Other 1234") => "U29tZVRleHQgb3IgT3RoZXIgMTIzNA"

ToBase64Url(file)

ToBase64Url( [File] ) => "U29tZV..... .... .... IgMTIzNA"

Parameters

Name
Type
Required
Description

text

text

☑️

a text

file

file

☑️

a file

ToHex

The ToHex() function converts a text or number to its hexadecimal equivalent.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a hexadecimal value that is the equivalent of the provided text input or (integer) numeric input. For numeric values, decimals will be ignored - only the integer part of the value will be used for conversion.

Syntax

ToHex(text)

ToHex("qwertyuiop1234567890") =>"71776572747975696f7031323334353637383930"

ToHex(number)

ToHex(255) =>"FF"

ToHex(255.2) =>"FF"

ToHex(255.7) =>"FF"

Parameters

Name
Type
Required
Description

text

text

☑️

Original text to be converted to hexadecimal.

number

numeric

☑️

Numeric value to be converted to hexadecimal. Only the integer part of a number will be used, any decimals will be ignored.

ToLower

The ToULower() function converts text to lowercase.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a copy of text converted to lowercase.

Syntax

ToLower(text)

ToLower("NEW YORK") => "new york"

ToLower(1234) => Invalid expresssion

Parameters

Name
Type
Required
Description

text

text

☑️

a text

ToRichText

The ToRichText() function converts a text to HTML.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a copy of text that can be used as HTML.

If text is unknown [empty] is returned.

Syntax

ToRichText(text)

ToRichText("plain text without html tags but with some html codes &amp; &euro; some &eacute; characters.") => "plain text without html tags but with some html codes & € some é characters."

Parameters

Name
Type
Required
Description

text

text

☑️

a text

ToString

The ToString() function converts a value to text.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Note: this function uses the language setting of a portal when converting a value.

Returns a text representation of value.

Syntax

ToString(value)

ToString(Date(2016, 12, 31, 15, 45)) => "zaterdag 31 december 2016 15:45" {according to Dutch language}

ToString(unknownstring) => unknown

ToString(765432123456.78901, "#,##0.00") => "765432123456.78901"

ToString('World regions'.'EMEA') => "EMEA"

Parameters

Name
Type
Required
Description

value

☑️

a value of any type.

format

text

a text with the format to which value must be converted. This parameter only applies when converting a datetime, duration or number.

ToTitleCase

The ToTitleCase() function converts every first character of a word to uppercase.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a copy of text where all words start with an uppercase character.

Syntax

ToTitleCase(text)

ToTitleCase("The wind in the willows") => "The Wind In The Willows"

ToTitleCase(123) => Invalid expression

Parameters

Name
Type
Required
Description

text

text

☑️

a text

ToUpper

The ToUpper() function converts text to uppercase.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a copy of text converted to uppercase.

Syntax

ToUpper(text)

ToUpper("New York") => "NEW YORK"

TpUpper(1234) => Invalid expression

Parameters

Name
Type
Required
Description

text

text

☑️

a text

Trim

The Trim() function strips text of whitespace from both ends.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text where both trailing and leading whitespaces are removed from text.

Syntax

Trim(text)

Trim(" start with a space.") => "start with a space."

Trim(" start and end with spaces. ") => "start and end with spaces."

Trim("") => ""

Parameters

Name
Type
Required
Description

text

text

☑️

a text

UrlDecode

The UrlDecode() function translates an URL to regular text.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text where each special character in text is decoded. Returns Invalid expression if the parameter is not a text.

Syntax

UrlDecode(text)

UrlDecode("\"Line 1\"\n'Line 2'") => "Line 1" 'Line 2'

Parameters

Name
Type
Required
Description

text

text

☑️

a text in URL format.

UrlEncode

The UrlEncode() function makes a text compatible to be used as an URL.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text where each special character in text is URL escaped. Returns Invalid expression if the parameter is not a text.

Syntax

UrlEncode(text)

UrlEncode("\"Line 1\"\n'Line 2'") => "%22Line+1%22%0a%27Line+2%27"

Parameters

Name
Type
Required
Description

text

text

☑️

a text

XmlAttributeEncode

The XmlAttributeEncode() function encodes the given text such that is can safely be used inside an XML attribute.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a text that can safely be used inside an XML attributel. Returns Invalid expression if the parameter is not a text.

Syntax

XmlAttributeEncode(text)

XmlAttributeEncode("\"Line 1\"\n'Line 2'") => "Line 1" 'Line 2'

Parameters

Name
Type
Required
Description

text

text

☑️

a text that is used as an XML attribute

XmlEncode

The XmlEncode() function converts a text to an XML encoded text.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns an XML encoded text. Returns Invalid expression if the parameter is not a text.

Syntax

XmlEncode(text)

XmlEncode("\"Line 1\"\n'Line 2'") => "Line 1" 'Line 2'

Parameters

Name
Type
Required
Description

text

text

☑️

a text that is used in an XML element

XPath

The XPath() function executes the given XPath query on XML text and returns the result as text.

Follow this link to learn more about XPath.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns an text that is the result of an xpath query. Returns Invalid expression if the parameter is not a text.

Syntax

XPathL(xml,xpath)

XPath([Settings.BookStoreXml], "//book[1]/title") => Everyday Italian

Parameters

XPathList

The XPathList() function executes the given XPath query on XML text and returns the result as a text array.

Follow this link to learn more about XPath.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns an text array that is the result of an xpath query. Returns Invalid expression if the parameters are not valid according to type.

Syntax

XPathList(xml,xpath)

XPathList([Settings.BookStoreXml], "//book/price[text()]") => 30.00, 29.99, 49.99, 39.95

Parameters

Loading...