Last Index Of

Overview

Use the last index of transform to get the last location of a specific substring within an incoming value. This transform is often useful in conjunction with the substring transform for getting parts of strings that can be dynamic in length or composition. If the substring you are searching for does not occur within the data, the transform returns -1.

Other Considerations

If the substring you are searching for occurs multiple times within the incoming data, the transform returns the location of the last occurrence. If you want the first occurrence of a substring, use the Index Of transform. If you want an occurrence that is neither first nor last, use the Substring transform.

Transform Structure

The lastIndexOf transform requires only the substring you want to search for, along with the transform's type and name attributes:

{
  "attributes": {
    "substring": "admin_"
  },
  "type": "lastIndexOf",
  "name": "Last Index Of Transform"
}

Attributes

• Required Attributes

  • type - This must always be set to lastIndexOf.
  • name - This is a required attribute for all transforms. It represents the name of the transform as it will appear in the UI's dropdown menus.
  • substring - This is the string whose beginning location within the incoming data you want to find.

• Optional Attributes

  • requiresPeriodicRefresh - This true or false value indicates whether the transform logic should be reevaluated every evening as part of the identity refresh process.
  • input - This is an optional attribute that can explicitly define the input data passed into the transform logic. If no input is provided, the transform takes its input from the source and attribute combination configured with the UI.

Examples

The "admin_" substring only occurs once at the very beginning of the input string, so this transform returns 0.

Input: "admin_jsmith"
Output: "0"

Transform Request Body:

{
  "attributes": {
    "substring": "admin_"
  },
  "type": "lastIndexOf",
  "name": "Last Index Of Transform"
}

---

 

While the letter "b" occurs multiple times throughout the input string, the last time it occurs is within index location 7, so this transform returns that value.

Transform Request Body:

Input: "abcabcabc"
Output: "7"

{
  "attributes": {
    "substring": "b"
  },
  "type": "lastIndexOf",
  "name": "Last Index Of Transform"
}