outwit.com
The Datasheet Right-Click Menu

In all datasheets, additional features can be accessed with a right click on the selected items.

Available options vary with the view and the license of your product.

Edit

Gives access to the Edit sub-menu, with the standard Editing functions.

Duplicates...

Gives access a sub-menu to select or delete cell duplicates (rows containing an identical value to the selected cell in the same column) or row duplicates (rows where all cells are identical to the cells of the selected row). It is also possible, through the same menu, to select or delete all cell or row duplicates of the datasheet.

Open URL in a New Window

When the selected data contains a URL, it will be opened in a new browser window.

Browse Through Selected URLs

The program explores all page links included in the current selection. During the exploration, all active extraction processes will be executed depending on the settings in the bottom panel of each view.

Apply Scraper to Selected URLs

When this function is invoked, XML HTTP requests are sent to all the selected URLs, to retrieve the source code of each one. The most relevant scraper is applied to it, without loading images etc. and without any other extraction being performed. All extracted data is sent to the Scraped view (which is not emptied during the process, regardless of the state of the Empty checkbox).

Normalize Figures

When this function is executed on a selection, the data contained in each selected cell of the selected column is converted to the corresponding value in metric units (if a numerical value is found with a non-metric unit).

To Units: Values will be converted to meters, square meters, cubic meters, grams etc.
To k Units: Values will be converted to kilometers, square kilometers, kilograms etc.

Editing Functions

Insert, delete, edit, copy and empty functions are available for cells. Columns can be inserted or deleted .

Insert Rows

The Insert Rows function allows you to generate strings using the Query Generation Matrix format.

Send Cell(s) to Queries

Sends the content of selected column in the selected rows to a directory of Queries.

New Directory: A new directory will be created with the selected items.
directoryName: The selected items will be sent to the chosen directory.

Send Links(s) to Queries

Sends the first URL found in the selected rows to a directory of Queries.

New Directory: A new directory will be created with the selected items.
directoryName: The selected items will be sent to the chosen directory.

Select All

Selects all rows of the datasheet.

Invert Selection

Deselects all selected rows of the datasheet and selects all rows that were not selected.

Select Similar

Selects all rows of the datasheet with content similar to that of the the selected cell. The default threshold used for determining similarity is 40 (0 selecting only identical values and 100 selecting everything). Use the sub-menu items to increase or decrease the threshold and select more or less rows.

Select Identical

Selects all rows of the datasheet with content identical to that of the the selected cell.

Select Different

Selects all rows of the datasheet with content different from that of the the selected cell.

Export Selection as...

Exports the selected data to a file on your hard disk, in one of the available formats (Excel, CSV, HTML, SQL).

Download Selected Files

Dowloads and saves to the current destination folder on your hard disk, all documents and images found in the selected rows.

Download Selected Files in...

Dowloads all documents and images found in the selected rows, openning the folder picker to let you decide where you want the files to be saved.