v2.2.0
v2.2.0v2.1.0v2.0.0v1.2.0

Text Functions

Contains

Returns a boolean value indicating whether a specified substring occurs within the calling string. This function performs a case-sensitive comparison.

Syntax

<String>.Contains(substring)

Arguments

  • substring - the string to seek.

Examples

You can use the following expression to find out whether the current ProductName field value contains the MP3 string.

{ProductName.Contains("MP3")}

EndsWith

Returns a boolean value indicating whether the end of the calling string instance matches a specified string. This function performs a case-sensitive comparison.

Syntax

<String>.EndsWith(str)

Arguments

  • str - the string to compare to the substring at the end of the calling string.

Examples

You can use the following expression to find out whether the current ProductName field value ends with the player string.

{ProductName.EndsWith("player")}

IndexOf

Returns the zero-based index of the first occurrence of a specified string within the calling string. The method returns -1 if the string is not found. This function performs a case-sensitive comparison.

Syntax

<String>.IndexOf(str, [startIndex])

Arguments

  • str - the string to seek.
  • startIndex - an optional number indicating the search starting position

Examples

You can use the following expression to return the first whitespace's position in the current ProductName field value.

{ProductName.IndexOf(" ")}

InStr

Returns a number specifying the 1-based position of the first occurrence of one string within another.

Syntax

InStr(string1, string2)

Arguments

  • string1 - the string being searched.
  • string2 - the string to seek.

Examples

You can use the following expression to return the first whitespace's position in the current ProductName field value.

{InStr(ProductName, " ")}

LastIndexOf

Returns the zero-based index of the last occurrence of a specified string within the calling string. The method returns -1 if the string is not found. This function performs a case-sensitive comparison.

Syntax

<String>.LastIndexOf(str, [startIndex])

Arguments

  • str - the string to seek.
  • startIndex - an optional number indicating the search starting position

Examples

You can use the following expression to return the last whitespace's position in the current ProductName field value.

{ProductName.LastIndexOf(" ")}

Replace

Returns a new string in which all occurrences of a specified string in the calling string are replaced with another specified string.

Syntax

<String>.Replace(oldValue, newValue)

Arguments

  • oldValue - the string to be replaced.
  • newValue - the string to replace all occurrences of oldValue.

Examples

You can use the following expression to remove all whitespaces in the current ProductName field value.

{ProductName.Replace(" ", "")}

StartsWith

Returns a boolean value indicating whether the beginning of the calling string matches the specified string. This function performs a case-sensitive comparison.

Syntax

<String>.StartsWith(str)

Arguments

  • str - the string to compare to the substring at the beginning of the calling string.

Examples

You can use the following expression to find out whether the current ProductName field value starts with the TV string.

{ProductName.StartsWith("TV")}

Substring

Returns a substring from the calling string. The substring starts at a specified position and has a specified length.

Syntax

<String>.Substring(startIndex, [length])

Arguments

  • startIndex - the zero-based starting position of a substring in the calling string.
  • length - an optional number of characters in the substring.

Examples

You can use the following expression to extract the substring starting from the first whitespace's position from the current ProductName field value.

{ProductName.Substring(productName.indexOf(" ") + 1)}

ToLower

Returns a copy of the calling string converted to lower case.

Syntax

<String>.ToLower()

Examples

You can use the following expression to convert the current ProductName field value to lower case.

{ProductName.ToLower()}

ToUpper

Returns a copy of the calling string converted to upper case.

Syntax

<String>.ToUpper()

Examples

You can use the following expression to convert the current ProductDescription field value to upper case.

{ProductDescription.ToUpper()}

Trim

Returns a new string in which all leading and trailing white-space characters from the calling string are removed.

Syntax

<String>.Trim()

Examples

You can use the following expression to remove all leading and trailing white-space characters from the current value of the ProductName field.

{ProductName.Trim()}

TrimEnd

Returns a new string in which all trailing white-space characters from the calling string are removed.

Syntax

<String>.TrimEnd()

Examples

You can use the following expression to remove all trailing white-space characters from the current value of the ProductName field.

{ProductName.TrimEnd()}

TrimStart

Returns a new string in which all leading white-space characters from the calling string are removed.

Syntax

<String>.TrimStart()

Examples

You can use the following expression to remove all leading white-space characters from the current value of the ProductName field.

{ProductName.TrimStart()}