{"id":12457,"date":"2022-10-28T11:35:21","date_gmt":"2022-10-28T11:35:21","guid":{"rendered":"https:\/\/fhug.org.uk\/kb\/?post_type=kb_article&p=12457"},"modified":"2022-10-28T11:35:21","modified_gmt":"2022-10-28T11:35:21","slug":"copy-a-query-result-set-to-a-table-in-notes-or-book-item","status":"publish","type":"kb_article","link":"https:\/\/www.fhug.org.uk\/kb\/kb-article\/copy-a-query-result-set-to-a-table-in-notes-or-book-item\/","title":{"rendered":"Copy a Query Result Set to a Table in Notes or Book Item"},"content":{"rendered":"

Introduction<\/h2>\n

A query can produce very informative tabulated data that may need to be captured in a table in either a rich text Notes<\/em> field or a Free Text<\/em> item in a Book<\/em>. That data transfer cannot be performed within \u0192h<\/span><\/span> so the process described below is a workaround.<\/p>\n

Copy a Result Set to a Rich Text Table<\/h2>\n

This process seems long-winded when written out but is actually quite fast in practice.<\/p>\n

    \n
  1. In the \u0192h<\/span><\/span> Query Result Set select all the cells and copy them to the clipboard.
    \nEither drag the cursor across all the cells, or select top left cell, hold down the Shft key and select bottom right cell, or use the Ctrl-A keyboard shortcut.
    \nEither click the \"\" Copy Selected Cells<\/em> button in the toolbar, or use the Ctrl-C keyboard shortcut, to copy to the clipboard.<\/li>\n
  2. Paste the cells into a word-processor document (MS Word or OpenOffice) and remove the string quotes \"<\/code><\/strong>.
    \nIn the word-processor, click the Paste button, or use the Ctrl-V keyboard shortcut, to paste all the cell text from the clipboard.
    \nUse the Replace function<\/glwrap> to Find every \"<\/code><\/strong> and Replace with nothing to Replace All the string quotes.<\/li>\n
  3. Convert the selected cell text to a table, and format as required.
    \nDrag the cursor over all the cell text, or select top left character, hold down Shft key and select bottom right character, or use the Ctrl-A keyboard shortcut, to select all the text.
    \nIn MS Word, use the Insert > Table > Convert Text to Table…<\/em> command with the options below and click OK, or use a similar option in your chosen word-processor.
    \n\"Convert
    \nInsert a new first row in the table and enter the required column headings.
    \nFormat the table as required, e.g. bold heading text, justify columns to right or centre.<\/li>\n
  4. In \u0192h<\/span><\/span> open a rich text window and copy the table.\n