Get Field Value From Table In Description

Question

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

Derek LoGrande · Answer

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

Bill Sheboy · Answer

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