How can I extract just one word with help of transform?

Hello SailPoint Family,

How can I extract the word ‘keep’ from this identity attribute with the help of transform?

Thank you
Best Regards

Hi @Ritabhatta005

I think you can use the split transform, in a nested fashion. What is the expression you are expecting? Is always of the form User (KEEP XXXXXXX?

{
  "attributes": {
    "delimiter": " ",
    "index": 0,
    "input": {
        "attributes": {
           "delimiter": "(",
           "index": 1
         },
        "type": "split"
    }
  },
  "type": "split"
}

Inner split should divide phrase between "User " and “KEEP 11/26/2024 bj)”, and will return second token. Using “KEEP 11/26/2024 bj)” as a new input, outter transform will divide phrase between KEEP and 11/26/2024 bj), returning first token.

You can use Substring Transform. You have to specify begining index and end index. It’s that simple.