author Hans-Jörg Bibiko category Query Editor command # read STDIN which contains the string data coming from the Query Editor # and pipe it to the following perl script cat | perl -ne ' # delete final line ending chomp; # substitute TABs by SPACEs s/\t/ /g; # escape " s/"/\\"/g; # output text and pipe it to sed print "\"".$_."\" . \"\\n\" .\n"' | # delete last ‘"\n" .’ (the 9 last characters) sed '$ s/.........$//' | # append ; sed '$ s/$/;/' | # pipe the result to the UNIX command pbcopy which pastes # the result into the clipboard; # __CF_USER_TEXT_ENCODING=$UID:0x8000100:0x8000100 tells pbcopy # that the string is UTF-8 encoded __CF_USER_TEXT_ENCODING=$UID:0x8000100:0x8000100 pbcopy contact znvy@ovovxb.qr description Takes the current query or the selection and copies it as a single line quoted multi-line string by appending a ; into the pasteboard for usage in other IDEs as e.g. PHP code snippet. Example: SELECT a FROM b ORDER BY c DESC will copy "SELECT a" . "\n" . " FROM b" . "\n" . " ORDER BY c DESC"; Version 1.0 input selectedtext input_fallback currentquery keyEquivalent name Copy Single Line Quoted output none scope inputfield tooltip Takes the current query or the selection and copies it as a single line quoted multi-line string by appending a ; into the pasteboard uuid CDAC825A-AE80-4544-9DBB-8E68A5C540D0 isDefaultBundle