I am trying to create a table output formatting that matches the style of Jira tables. Jira uses pipes like in the knitr::kable(format = "pipe") output but differs with regards to the column headers. Here is an example of my current table format using the knitr package:
data<span>(</span><span>"BOD"</span><span>)</span>
BOD <span>%>%</span> tibble<span>::</span>tibble<span>(</span><span>)</span> <span>%>%</span>
head<span>(</span>n <span>=</span> <span>10</span><span>)</span> <span>%>%</span>
knitr<span>::</span>kable<span>(</span>format <span>=</span> <span>"pipe"</span><span>)</span>
<span>></span> <span>|</span> Time<span>|</span> demand<span>|</span>
<span>|</span><span>-</span><span>-</span><span>-</span><span>-</span><span>:</span><span>|</span><span>-</span><span>-</span><span>-</span><span>-</span><span>-</span><span>-</span><span>:</span><span>|</span>
<span>|</span> <span>1</span><span>|</span> <span>8.3</span><span>|</span>
<span>|</span> <span>2</span><span>|</span> <span>10.3</span><span>|</span>
<span>|</span> <span>3</span><span>|</span> <span>19.0</span><span>|</span>
<span>|</span> <span>4</span><span>|</span> <span>16.0</span><span>|</span>
<span>|</span> <span>5</span><span>|</span> <span>15.6</span><span>|</span>
<span>|</span> <span>7</span><span>|</span> <span>19.8</span><span>|</span>
Instead of using a line to separate the headers from the column content, Jira has a slightly different switch syntax:
<span>||</span> Time<span>||</span> demand<span>||</span>
<span>|</span> <span>1</span><span>|</span> <span>8.3</span><span>|</span>
<span>|</span> <span>2</span><span>|</span> <span>10.3</span><span>|</span>
<span>|</span> <span>3</span><span>|</span> <span>19.0</span><span>|</span>
<span>|</span> <span>4</span><span>|</span> <span>16.0</span><span>|</span>
<span>|</span> <span>5</span><span>|</span> <span>15.6</span><span>|</span>
<span>|</span> <span>7</span><span>|</span> <span>19.8</span><span>|</span>
Currently, I am removing the ›separation row‹ and modifying the first row:
BOD <span>%>%</span> tibble<span>::</span>tibble<span>(</span><span>)</span> <span>%>%</span>
head<span>(</span>n <span>=</span> <span>10</span><span>)</span> <span>%>%</span>
knitr<span>::</span>kable<span>(</span>format <span>=</span> <span>"pipe"</span><span>)</span> <span>-></span> tmp
tmp <span><-</span> tmp<span>[</span><span>-</span><span>2</span><span>]</span>
tmp<span>[</span><span>1</span><span>]</span> <span><-</span> stringr<span>::</span>str_replace_all<span>(</span>tmp<span>[</span><span>1</span><span>]</span><span>,</span> pattern <span>=</span> <span>"\\|"</span><span>,</span> replacement <span>=</span> <span>"||"</span><span>)</span>
tmp <span>%>%</span> writeClipboard<span>(</span><span>)</span> <span># Paste into Jira</span>
<span># Output:</span>
<span>||</span> Time<span>||</span> demand<span>||</span>
<span>|</span> <span>1</span><span>|</span> <span>8.3</span><span>|</span>
<span>|</span> <span>2</span><span>|</span> <span>10.3</span><span>|</span>
<span>|</span> <span>3</span><span>|</span> <span>19.0</span><span>|</span>
<span>|</span> <span>4</span><span>|</span> <span>16.0</span><span>|</span>
<span>|</span> <span>5</span><span>|</span> <span>15.6</span><span>|</span>
<span>|</span> <span>7</span><span>|</span> <span>19.8</span><span>|</span>
Is there a way to customise the kable() output in order to achieve Jira compatibility?