Fetching substring in Email templates

[tbhavya]

Hi Team,

We have a requirement to display only Security group name in email templates.
In the entitlement value we have "Job and Position Administrator (UB-HR-Job_and_Position_Administrator)" which is combination of security group name and Tenent security Id.
Requirement is to display only "Job and Position Administrator" while sending email notification and we tried few options but that didn't work

i.e,
<div>Entitlement Value: ${entitlement_values}.get[0].substring ${entitlement_values}.indexOf(" (",1) </div>
<div>Entitlement value: entitlement_values.substring(entitlement_values.indexOf(" ("),1)) </div>
<div>Entitlement Value: <% if (${entitlement_values}.contains(" (")) print "SUBSTRING_INDEX(${entitlement_value}, " (", 1) else print "${entitlement_value}" %></div><br>

Could you please advise how can we achieve this.

Thanks,

Bhavya.

[rushikeshvartak]

Is it possible to store value in entitlement customproperty / display name / glossary while import? 

Which connector is used? 

[tbhavya]

Hi Rushikesh,

We are using "Workday connector"

Not possible to store value anywhere as we don't have mapping available at the connector level

[sahajranajee]

@tbhavya ,

Can you tell me which email templates are you trying this in?

[tbhavya]

Hi Sahaj,

We are using notification email template as shown in the screenshot below.

[sahajranajee]

Hi @tbhavya ,

This worked for me :

${entitlement_values.collect{it.toString().indexOf("(") == -1 ? it : it.toString().substring(0, it.toString().indexOf("(") -1)}}

Entitlement Value : 

Email : 

[tbhavya]

Hi Sahaj,

Thank you. It worked.

However, Is it possible to remove square bracket [] from security group name?

i.e., Job and Position Administrator

[rushikeshvartak]

${entitlement_values.collect{it.toString().indexOf("(") == -1 ? it : it.toString().substring(0, it.toString().indexOf("(") -1).replaceAll("\\[","").replaceAll("\\]","")}}

[sahajranajee · Accepted solution]

@tbhavya 

I tried the following for it, worked :

${entitlement_values.collect{it.toString().indexOf("(") == -1 ? it : it.toString().substring(0, it.toString().indexOf("(") -1)}.toListString().replaceAll('\\[|\\]','')}

Email :

[tbhavya]

It worked. Thank you

Regards,

Bhavya.

[sahajranajee]

Thanks @tbhavya 
Please mark the answer as solution to close the topic.