Easy Insight Logo
Call 1-(720)-316-8174

Text Functions

indexof returns the index of a specified character.

indexof([Field], "Z")

would return a zero-offset value of 2 on a row containing a value in Field of XYZ.

lastindexof returns the last index of a specified character.

lastindexof([Field], "Z")

would return a zero-offset value of 2 on a row containing a value in Field of Z Z.

regex uses regular expression matching to parse text.

regex([Field], "A([0-9])*", 0)

would return A312 in an example of Code A312 Test.

split breaks the selected text value apart by a delimiter and returns the selected part.

split([Field], "|", 1)

on a value of A|B|C would return B.

tail returns the last N characters of the specified text value.

tail([Field], 3)

on a value of ABC DEF would return DEF.

json parses a field containing JSON using a JSON Path expression.

json([Field], "$.name")

would return a value of the name field found on the JSON structure in the data.

substring returns the subset of characters between the specified start and end indices.

substring([Field], 5, 10)

returns the characters starting at the 5th letter and ending at the 10th letter of the value in Field.

substring([Field], 5)

returns the characters starting at the 5th letter of the value in Field.

lower returns a value in lower case.

lower([Field])

upper returns a value in upper case.

upper([Field])

uniqueconcat creates a comma separated list of values. For example, you might have multiple assignees possible per task, but want to see all assignees in a single table cell. To do this, you could use a calculation of:

uniqueconcat([Task ID], [Assignee Name)

For each unique task ID, it will combine the set of matching Assignee Names so that you'll get "Jim, Anna" or "Bob, Mike, Nancy" as values per task.

RESOURCES
Twitter Logo Facebook Logo Linkedin Logo Instagram Logo