Extract strings from table in description and assign to fields
Hi,
I have a table in Description with several rows as you can see below. I want to:
1. Extract value against Space Key - "nyleseries2" in the example and add it as a label to the issue. Space Key can be between 5-30 characters but always one string.
2. Extract value against Wiki Login in the Description field- and if the user exists in JIRA users, assign the value to Reporter field so that the user gets notified, else, skip assigning. The Wiki Login value can be what a generic email address can go for 12-40 characters I think?
I have the following value table in the description field:
KTF Tech Documentation Feedback
You are receiving this notification because documentation feedback has been submitted.
Feedback Details | |
Company | KTF Tech |
Name | John Doe |
Wiki Login | johndoe@ktftech.com |
Space Name | Nyle Series 2.0 |
SpaceKey | nyleseries2 |
Page | Getting Started |
Satisfaction Score | 7 |
Was Document Helpful | Yes |
| Reason for Score | All Good |
How to Improve | Please consider adding more videos maybe? |
Feedback Type | ONLINE |
Allow to Contact | Yes |
Jira issue submitted | Yes |
In Text View of teh JIRA Description field, the table appears in Wiki markup syntax like this:
h2. {color:#ff0000}KTF Tech Documentation Feedback{color}
{color:#000000}You are receiving this notification because documentation feedback has been submitted.{color}
|h4. {color:#993300} Feedback Details{color}|h4. |
|h4. Company|KTF Tech|
|h4. Name|John Doe|
|h4. Wiki Login|johndoe@ktftech.com|
|h4. Space Name|Nyle Series 2.0|
|h4. SpaceKey|nyleseries2|
|h4. Page|[Getting Started|https://conf.ktftech.com/nyleseries2/getting-started]|
|h4. Satisifcation Score|7|
|h4. Was Document Helpful|Yes|
|h4. Reason for Score|I found what I was looking for. Great info on this page.|
|h4. How to Improve|Please consider adding more videos maybe?|
|h4. Feedback Type|ONLINE|
|h4. Allow to Contact|Yes|
|h4. Jira issue submitted|Yes|
I have checked several resources and it seems I need to use match function and maybe something else to extract the required strings and assign. Can anyone please help?
When I try passing this value to Labels: {{issue.description.match(".*\|SpaceKey\|(\w+)\|.*")}}, I get error.
My Rule setup:
My Audit log:
