Kibana search results (exported to CSV) to JIRA table format

kibana_csv_jira.sh

# !/bin/bash

# Steps:
#   - Run query in Kibana
#   - Export results to CSV file: Share -> CSV Reports -> Generate CSV
#     (you may be required to "Save search" first. Use a temporary name and keep overwriting it to reduce entries)
#   - Download generated CSV once generated (it takes a short while)
#   - Run script on local file as shown below
#   - Profit
#
# Usage example:
# $ kibana_csv_jira.sh tmp_export_csv.csv
#
# Output in:
# /tmp/tmp_export_csv.csv.jira

# Requires: apt install csvkit
csvformat -T -Q \" -U 1 "$1" | sed -e 's/^"/|/g' -e 's/"$/|/g' -e 's/\t/|/g' -e 's/"//g' > /tmp/"$(basename "$1")".jira
echo "Output in:"
echo /tmp/$(basename "$1").jira