[{"id":"a20f26ac-cd31-4e4d-9454-1e035b0f1587","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"3604b8ce-1da0-413f-8274-7df0f7173573","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"7fce7040-1bb1-4a61-9fb7-2e19d569de50","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"0eb72dd3-8f8f-4039-93a8-500bbde2301e","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"ac046cee-82b9-4edf-a642-ae6d7cb21ebf","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"75b66fd4-b740-443d-bc6e-1782048b60a6","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"dde44832-bb5c-45f3-8ebf-3badbc613cd9","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"43de3664-261b-4cf9-9945-fb519251f4c7","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"2f064d57-b088-4bc5-a628-4e0d7e1a0c65","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"f290406b-ced1-4c52-abad-979160a79f6b","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"1864834b-08ce-43f1-891b-c3cca6e04e95","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"f96cfec1-420c-4ca7-ab0a-cab482731073","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"3f2ea860-c764-43d8-ae3f-6e3b0314ce67","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"81eb70e8-f770-4384-9167-bc7c755ad052","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"d0dff477-9f56-483a-a9fc-cab648905b41","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"793a62d7-460d-4699-9304-edb2941268ac","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"2d6ebfad-f7d1-4cc5-8ba1-fdace3472056","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"c8c7b5d5-f5bd-4b68-a12f-3aae9804a844","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"577a09da-dea1-42db-812f-4eeaa9274ece","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"8ddd80d5-886f-41b8-8e3f-f73aa8146c8d","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"e0909540-8bde-4587-bb4d-02445746db2a","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"464b8e03-462d-4aed-8818-05d32ec3bf00","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"f235557b-9781-471f-bf03-38bae6e3e953","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"fd5d021d-0210-4d74-ba42-1a39ef14a385","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"548568fe-dbd1-4da5-a489-d9b3edf75329","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"a0c823ed-e22b-493b-aded-4d201c0fa480","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"d19bc9cd-ff53-4b0d-ab7e-a68c1497c4c6","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"94759fce-692f-4779-b5f3-fce5c58f242c","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"27658163-a479-432f-a192-dbed286beb3e","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]}]
Returns a boolean value indicating whether a specified substring occurs within the calling string. This function performs a case-sensitive comparison.
Syntax
Contains(str
, substring
)
Arguments
str
- the string to inspect
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.
{Contains(ProductName, "MP3")}
Returns an integer value representing the length of a specified string. The length of a string is the number of characters it contains.
Syntax
Len(str
)
Arguments
str
- the text string to measure.
Examples
You can use the following expression to find out the length of the current productName
field value.
{Len(productName)}
Returns a boolean value indicating whether one text string ends with another. This function performs a case-sensitive comparison.
Syntax
EndsWith(str1
, str2
)
Arguments
str1
- the text string to test.
str2
- the text string to search for at the end of str1
..
Examples
You can use the following expression to find out whether the current productName
field value ends with the player
string.
{EndsWith(productName, "player")}
Returns the zero-based index of the first occurrence of one text string within another. The method returns -1 if the string is not found. This function performs a case-sensitive comparison.
Syntax
IndexOf(str1
, str2
, [startIndex
])
Arguments
str1
- the string being searched.
str2
- 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.
{IndexOf(productName, " ")}
Returns a number specifying the 1-based position of the first occurrence of one string within another.
Syntax
InStr(str1
, str2
)
Arguments
str1
- the string being searched.
str2
- 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, " ")}
Returns the zero-based index of the last occurrence of one text string within another. The method returns -1 if the string is not found. This function performs a case-sensitive comparison.
Syntax
LastIndexOf(str1
, str2
, [startIndex
])
Arguments
str1
- the string being searched.
str2
- 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.
{LastIndexOf(productName, " ")}
Returns a new string, in which a portion of a string of text is replaced with another string.
Syntax
Replace(str
, oldValue
, newValue
)
Arguments
str
- the string to operate on.
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 white spaces in the current productName
field value.
{Replace(productName, " ", "")}
Returns a boolean value indicating whether one text string starts with another. This function performs a case-sensitive comparison.
Syntax
StartsWith(str1
, str2
)
Arguments
str1
- the text string to test.
str2
- the text string to search for at the beginning of str1
.\
Examples
You can use the following expression to find out whether the current productName
field value starts with the TV
string.
{StartsWith(productName, "TV")}
Returns a substring from the specified string. The substring starts at a specified position and has a specified length.
Syntax
Substring(str
, startIndex
, [length
])
Arguments
str
– the text string to extract a substring from
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.
{Substring(productName, IndexOf(productName, " ") + 1)}
Returns a copy of the specified string converted to lower case.
Syntax
ToLower(str
)
Arguments
str
– the text string to operate on
Examples
You can use the following expression to convert the current productName
field value to lower case.
{ToLower(productName)}
Returns a copy of the specified string converted to upper case.
Syntax
ToUpper(str
)
Arguments
str
– the text string to operate on
Examples
You can use the following expression to convert the current productDescription
field value to upper case.
{ToUpper(productDescription)}
Returns a new string in which all leading and trailing white-space characters from the specified string are removed.
Syntax
Trim(str
)
Arguments
str
– the text string to operate on
Examples
You can use the following expression to remove all leading and trailing white-space characters from the current value of the productName
field.
{Trim(productName)}
Returns a new string in which all trailing white-space characters from the specified string are removed.
Syntax
TrimEnd(str
)
Arguments
str
– the text string to operate on
Examples
You can use the following expression to remove all trailing white-space characters from the current value of the productName
field.
{TrimEnd(productName)}
Returns a new string in which all leading white-space characters from the specified string are removed.
Syntax
TrimStart(str
)
Arguments
str
– the text string to operate on
Examples
You can use the following expression to remove all leading white-space characters from the current value of the productName
field.
{TrimStart(productName)}