Fetch information from table in description to custom fields

[Olof Nysten]

I get a lot of issues generated from my customers datacenters. The issue description contains a table with information that I want to enter in custom fields with automation.

The table can look something like this

Alert Type:	Device Alarm
Severity:	Critical
Alert Level:	NewYork-Email-notification
Device:	ESU-RQ7 (101.159.160.183)

Is it possible to fetch through Regex?

[Martin Bayer _MoroSystems_ s_r_o__ · Accepted solution]

Hi @Olof Nysten welcome on the community. Can you describe the whole proces in more detail?

Issues are created automatically with description which contains table? How do you want to process it?

[Olof Nysten]

Thank you.

The issues are created from incoming e-mails. These e-mails contains a table with all the information I need for custom fields. These field are then used in integrations with other systems.

As there are hundreds of issues created, it would be great if I can create an automation that fills the custom fields.

[Martin Bayer _MoroSystems_ s_r_o__]

Hi @Olof Nysten , thank you for the information. Give me few days, I will try to play with it a little... I'm quite curious :)

[Martin Bayer _MoroSystems_ s_r_o__]

Hi @Olof Nysten I think I almost have it :).

I prepared issue with a table:

And I prepared an automation with following setup:

I logged my description to find out what is its format and it was:

|greeting|Hello| |name|Martin| |last name|Bayer|

 I hope it will help... :) 

[Olof Nysten]

Thank you very much! That was exactly it. I have experimented with expressions like that but never found the solution.

[Martin Bayer _MoroSystems_ s_r_o__]

cool, you are welcome :)