String

CONTAINSWITHSEP

The CONTAINSWITHSEP function checks if a string contains a substring, using a separator.

Syntax: CONTAINSWITHSEP(String, Substring, Separator)

String: The main text to search in. Substring: The text to search for. Separator: The character(s) used to separate items in the string.

Example: CONTAINSWITHSEP("apple,banana,orange", "banana", ",") The function will return true.

FIND

The FIND function finds the position of a substring within a string.

Syntax: FIND(Substring, String)

Substring: The text to find. String: The text to search in.

Start Position (optional): Starting position to find the Substring

Example: FIND("for", "example for demonstration") The function will return 9.

GETLENGTH

The GETLENGTH function returns the length of a string.

Syntax: GETLENGTH(String)

String: The text value.

Example: GETLENGTH("example") The function will return 7.

INDEXOF

The INDEXOF function returns the position of a substring in a string.

Syntax: INDEXOF(String, Substring)

String: The text to search in. Substring: The text to find.

Example: INDEXOF("demonstration", "strat") The function will return 5.

LEFT

The LEFT function is a part of the string functions in the formula editor, used to extract a specific number of characters from the beginning (left side) of a string.

Syntax:

LEFT(String, Number of characters)

String: The text value from which characters will be extracted starting from the left.

Number of Characters: The total number of characters to return from the beginning of the string.

Example:

Let's say you have the string " example for demonstration" and you want to extract first 7 characters. You will write:

LEFT(“example for demonstration”, 7)

The function will return “example”.

NUMBERTOWORDS

The NUMBERTOWORDS function converts a number to its word representation.

Syntax: NUMBERTOWORDS(Number)

Number: The numeric value.

Example: NUMBERTOWORDS(123) The function will return "one hundred twenty-three".

REPLACESYMBOL

The REPLACESYMBOL function replaces a symbol in a string with another symbol.

Syntax: REPLACESYMBOL(String, OldSymbol, NewSymbol)

String: The text value. OldSymbol: The symbol to replace. NewSymbol: The replacement symbol.

Example: REPLACESYMBOL("1-2-3", "-", "/") The function will return "1/2/3".

RIGHT

The RIGHT function is a part of the string functions in the formula editor, used to extract a specific number of characters from the end (right side) of a string.

Syntax: RIGHT(String, Number of characters)

String: The text value from which characters will be extracted starting from the right.

Number of Characters: The total number of characters to return from the end of the string.

Example:

Let's say you have the string "example for demonstration" and you want to extract the last 7 characters. You will write:

RIGHT("example for demonstration", 7)

The function will return "ration".

SPLITSTRING

The SPLITSTRING function splits a string by separator and return the specified index item.

Syntax: SPLITSTRING(String, Separator)

String: The text value. Separator: The character(s) to split by.

Index: The index of item to return (starting from 1).

Example: SPLITSTRING("a,b,c", ",", 2) The function will return b.

STRINGTOUPPERCASE

The STRINGTOUPPERCASE function converts a string to uppercase.

Syntax: STRINGTOUPPERCASE(String)

String: The text value.

Example: STRINGTOUPPERCASE("hello") The function will return "HELLO".

SUBSTRING

The SUBSTRING function extracts a substring from a string.

Syntax: SUBSTRING(String, Start, Length)

String: The text value. Start: The starting position. Length: The number of characters to extract.

Example: SUBSTRING("demonstration", 3, 5) The function will return "onstr".

SUBSTRINGUSINGCHARACTER

The SUBSTRINGUSINGCHARACTER function extracts a substring using a specific character as a delimiter.

Syntax: SUBSTRINGUSINGCHARACTER(String, Character, Occurrence)

String: The text value. Character: The delimiter character. Occurrence: The occurrence to use for extraction.

Example: SUBSTRINGUSINGCHARACTER("a-b-c-d", "-", 2) The function will return "b".

XPATH

The XPATH function evaluates an XPath expression on XML data.

Syntax: XPATH(Xml, Expression)

Xml: The XML data. Expression: The XPath expression.

Example: XPATH("<root><a>1</a></root>", "/root/a") The function will return "1".