Column Settings

Column settings provides options that help manage columns and the data within such columns.

Elements of the Column Settings

1. View/edit data: Switches Data view over to Edit view.
2. Rename column: Renames the column header.
3. Set default value: Automatically set empty data points in the column to a default value.
4. Set regular expression: Allows user to input regular expression to match and/or replace for patterns in text
5. Use manual XPath: Allows user to input XPath to manually select elements of a web page from the HTML source code.
6. Clear data: Removes all data from a column.
7. Required field: Sets the column as required and omits any rows from the dataset when a cell for this column is empty.
8. Output HTML: Extracts the original HTML of the selected data point.
9. Capture this link's URL: Extracts the URL along with the link text.
10. Download content behind this link/Download images: Downloads the file behind a link or download the selected image.
11. Duplicate column: Creates a duplicate of the selected column to the right.
12. Add column: Adds a new column to the right of the selected column
13. Delete column: Deletes the selected column.
14. Resize column header: Resizes the column header for the selected column to try and fit the data.
15. Resize all column headers: Resizes all the column headers to fill the screen width.

Reordering Columns

To reorder columns you can drag-and-drop the column headers.

Renaming Multiple Columns

When renaming columns, you can click into one column header and use the Tab key to tab through other columns to rename those columns as well.