Hello SailPoint Family,
How can I extract the word ‘keep’ from this identity attribute with the help of transform?
Thank you
Best Regards
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.