Copies Sequel Pro result into JIRA's table format. Save with the Bundle Editor (as new Copy bundle).

Copy As JIRA Table

#!/usr/bin/php
<?php

/*
 * COPY AS JIRA TABLE by @daverogers
 * Copies Sequel Pro result into JIRA's table format. Save with the Bundle Editor (as new Copy bundle).
 *
 * Thanks to @jakob-stoeck for his example Gist!
*/

$in		= fopen('php://stdin', 'r');
$result = [];
$format = '||';
while( $line = fgetcsv( $in, 0, "\t" ) ) {
	$result[] = $format . implode( $format, $line ) . $format;
	$format = '|';
}
fclose( $in );
$cmd = 'echo '.escapeshellarg( implode( "\n", $result ) ).' | __CF_USER_TEXT_ENCODING='.posix_getuid().':0x8000100:0x8000100 pbcopy';
shell_exec( $cmd );