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

[Jacqueline Arrindell]

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.

[Kseniia Trushnikova · Accepted solution]

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]

Yes, that worked! Thank you @Kseniia Trushnikova .

[Bill Sheboy]

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]

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

Thanks.

[Bill Sheboy]

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.