how to capture the specif text from Email body / Description to Custom field using Jira automation

[Kishor Mudhili]

how to capture the specif text from Email (Descrption to Custom field using Jira automation

example: 

Weekly check completed with faults:

Room: STA Meeting Room
Location: Stallingborough

from the above Email (Description) i want to capture Room Information (example: STA Meeting Room) and should be updated in Jira Custom Field (Room), using Jira Autoamtion rules. please help me

i have tried with automation rules but not working. i have checked few articals but not working for me. 

[John Funk]

Hi Kishor,

Can you share a screenshot of the audit log for when it runs and what your log action shows?

[Patrick Tripodi]

Hi Kishor, 

You can try the following. {{Issue.description.substringBetween("Room: ", "Location: ")}}

This will retrieve STA Meeting Room. You can also add .trim to remove trailing white spaces so {{Issue.description.substringBetween("Room: ", "Location: ").trim}}

Cheers,

Patrick Tripodi
GLiNTECH