CopyQ Commands

readme.md

These are CopyQ commands I use for copying data out of spreadsheets and into SQL windows.

single-quoted-list.ini is good for creating an in clause from a single column of values.

values-grid.ini is good for creating the values section of an insert statement.

Installing these is quite easy:

1. Copy the script
2. Within Copyq hit F6 to bring up the Command editor
3. Now click the Paste Commands button

single-quoted-list.ini

[Command]
Command="
    copyq:
    var text = str(data(mimeText));
    var updated = text.split('\\n').map(x => `'${x}'`).join(',\\n');
    copy(mimeText, updated);
    paste();
    "
HideWindow=true
Icon=\xf00b
InMenu=true
Input=text/plain
Match=\\n
Name=Single &Quoted List

values-grid.ini

[Command]
Command="
    copyq:
    var text = str(data(mimeText));
    var updated 
      = text
      .split('\\n')
    // split line content by tab
      .map(line => '('+ line.split('\\t').map(x => `'${x}'`).join(',') + ')')
      .join(',\\n');
    copy(mimeText, updated);
    paste();
    "
HideWindow=true
Icon=\xf00a
InMenu=true
Input=text/plain
Match=\\t
Name=&Values List