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.

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.

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.

lower returns a value in lower case.

lower([Field])

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.

striphtml removes any HTML tag fields from the value.

striphtml([Field])

on a value of:

XY<br>Z

would return:

XYZ

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.

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

tail([Field], 3)

on a value of ABC DEF would return DEF.

trim removes any leading or trailing whitespace.

trim([Field])

on a value of XYZ would return XYZ.

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.

upper returns a value in upper case.

upper([Field])

RESOURCES
Twitter Logo