toJiraTable

Reads input from stdin and converts it to a JIRA table.

The first line it reads is used as the table header, and all subsequent lines are made into the body. Supports shell-style splitting of fields (you can use quotes to “group” items with spaces into a single field).

By default, it will split by whitespace, so each word becomes an item. The entire table, by default, will grow to the longest row, and fill in blanks where needed.

If you need to split by an alternative thing, such as two-spaces (if columns are seperated by two-or-more spaces, and contain characters with spaces between) there are various --split-by options available, see usage below. See usage and examples for more information.

Usage:

Usage: toJiraTable

Converts stdin to a JIRA table. If no arguments provided, it will use “shell-style” splitting

so quoting strings with spaces makes them a single column, otherwise spaces/tabs/whatever

splits. The first line passed in becomes the header, the remainder become the body.

By default, everything will be matched to the longest row. Any missing columns in a row will

be filled by blank columns at the end. Use --no-stretch to disable this.

Arguments:

--no-stretch - Do not stretch each row to the longest row. See above.

--split-header-by=X - Instead of using shell-style splitting, split by provided string for the header line

--split-body-by=X - Instead of using shell-style splitting, split by the provided string for body lines

--split-by=X - Split both header and body by the given string

--split-keep-empty - By default, using the --split-by* will strip empty columns. The default behaviour is

useful, in example: if a script outputs strings which are not quoted, but has at least two

spaces between each real column, using --split-body-by=’ ‘ will ensure that any place that

is separated by two or more spaces becomes a column. This option disables that feature.

Example Usage:

Simple split:

[myuser]$ ( echo ‘Hostname “Free Space”’; cat hostnames.txt ) | toJiraTable

||Hostname||Free Space||

|host1|500G|

|wwwprod1|120G|

|wwwdev1|11G|

More complicated split. In this case, we want the body to form columns any time there are at least two spaces:

(dataset)

[myuser]$ cat myData

Name Size Comment

George Jetson 500G The man from the future

Jeeves 200M Everyone’s favourite butlet

(convert to JIRA table)

[myuser]$ cat myData | ./toJiraTable --split-body-by=” “

||Name||Size||Comment||

|George Jetson|500G|The man from the future|

|Jeeves|200M|Everyone’s favourite butlet|

Tab-deliminated split:

(dataset):

[myuser]$ python -c “import sys; sys.stdout.write(repr(open(‘myData’, ‘rt’).read()).replace(’\\n’, ‘\n’) + ‘n’);”

“NametSizetComment

George Jetsont500GtThe man from the future

Jeevest200MtEveryone’s favourite butlet

“

(convert to JIRA table)

[myuser]$ cat myData | ./toJiraTable --split-by=’t’

||Name||Size||Comment||

|George Jetson|500G|The man from the future|

|Jeeves|200M|Everyone’s favourite butlet|