Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JIRA Automation: emailed issues list created w/ smart values: how to separate values by tab char?

Jacqueline Arrindell February 20, 2024

I can't seem to figure out how to insert a tab character to separate values in my list of issues that I generate and email in bulk via JIRA Automation using automation smart values. 

I can successfully create my email w/ correct list of issues - where issue values are separated by the pipe character "|". 

However, I would like to use a tab character to separate the values so that I can more easily / readily import this data into excel. 

As an example, I've tried appending a tab character to each smart value using the concat("\t") function:

{{#issues}}
{{key.concat("\t")}}{{resolution.name.concat("\t")}}
{{/}} 

But the "\t" is not producing a tab character; instead it gives me a space character. 

How do I add/append a TAB character?  Is this possible in Jira automation?

In advance, thanks for your help.

2 answers

1 accepted

1 vote
Answer accepted
Kseniia Trushnikova
Community Champion
February 20, 2024

Hi @Jacqueline Arrindell,

Try this:

{{#issues}}
<pre>{{key}}&#x9;{{resolution.name}}&#x9;</pre>
{{/}}

The <pre> tag defines preformatted text. &#x9; is a HTML entity for tabulations.

Jacqueline Arrindell February 20, 2024

Yes, that worked! Thank you @Kseniia Trushnikova .

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 20, 2024

Hi @Jacqueline Arrindell -- Welcome to the Atlassian Community!

Have you tried concatenating the code for tab instead, perhaps like this:

concat("\u0009")

 

Kind regards,
Bill

Jacqueline Arrindell February 20, 2024

Yes, I did try that as well. Same... resulted in a space and not a tab character.

Thanks.

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 20, 2024

Interesting...Where are you storing the result of the concat() operation?  I tried it updating the summary field and a tab was inserted.

Updated: I just noticed you are doing this in an email.

Like Jacqueline Arrindell likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events