Get Field Value From Table In Description

[Derek LoGrande]

Hi!

Trying to figure out the Jira Automation to get the Broker Code Value "BROK" out of a table that is embedded within the issue description so it can be used to populate a custom field. I've seen examples using Regex to get values across header rows, but not down below from column headers and I'm stumped. Any help would be appreciated!

Issue Description:

This is a notification that your group has a task to complete.

Responsible Group: Middle Office

Short Description: Set Up Broker in Appropriate Systems

Regional Broker Codes

Region	Broker Code	Broker Name	Broker LEI
AMER	BROK	TEST BROK	LEI123456789

[Bill Sheboy]

Hi @Derek LoGrande 

How many rows are in your table: just the header and one data row, or more data rows?

If there is one-and-only-one data row, and the columns are stable, using the text functions would probably work...requiring some experimentation to get correct.

If there are multiple rows, still with stable columns, they could be iterated and then parsed using the above approach.

But if the columns vary and "Broker Code" could be anywhere, that is a bit trickier.  It would require two steps: identify the column, and then parse the data.  The second one would likely require using a dynamically-built, regular expression and inline list iteration with the match() function.  The techniques are described in this article and could be applied to this case.

Kind regards,
Bill

[Derek LoGrande]

Hi Bill,

Columns are fixed. It could potentially be multiple rows, usually 1 row but no more than 4. I will try your suggestions and report back.

Many thanks!

-Derek