CCPN LogoVideo
& Manual

Working with Tables

Working with Tables

There are many different data sets in Analysis which can be viewed in tables, e.g. peak lists, chemical shift lists, NmrResidues, residues, multiplets, integrals, structures etc. These tables can be displayed by selecting them from the View menu, typing their keyboard shortcut or dragging them into the drop area from the sidebar. The tables share many general characteristics:

A dropdown menu at the top lets you select the dataset, e.g. which peak list, NmrChain etc. you want to view.

Columns which have a small pen in their header are editable. Double-click in a cell and then you can edit it.

Right-click on a column heading to select Column Settings... where you can select which columns to hide or show in your table.

Right-click on a column heading to go to the Search function or use shortcut FT (short for Filter Table). This generally operates on all cells visible in the table. This means repeated searches without clicking Reset in between will refine your search. Clicking Reset brings back the full table. Note that you can use a variety of filtering tools from the drop-down menu, including Equals, Includ, >, >=, <, <= etc.

Right-clicking in the table will enable you to export the table, either Export Visible Table to export only those columns and rows which are currently being shown, or Export All to export the full table (this will include the full raw data, i.e. no rounding). The supported export file formats include Excel (.xlsx), comma separated (.csv) and tab separated (.tsv) files.