Navigation :
field.r
field.r(source: text, separator: text, index: number) 🡒 text, pure function
Returns the nth field, zero-indexed from the right, in a text value that contains multiple sub-strings separated by a specified separator.
Example:
source = "a-b-c-d-"
show summary "" a1c3 with
field.r(source, "-", 0) // returns ""
field.r(source, "-", 1) // returns "d"
field.r(source, "-", 2) // returns "c"
This function is intended to facilitate parsing values that have been concatenated within a single table column.
See also